kitlizzy (kitlizzy) wrote in thequestionclub,
kitlizzy
kitlizzy
thequestionclub

Excel question

I'm tracking response times to requests for a work project, and I can't get Excel to compute the difference between the time submitted and the time resolved correctly.

What I have is:
Column A (Submitted Time)
6/10/05 8:00 AM

Column B (Resovled Time)
6/11/05 10:00 AM

The formula will give me a result of 2 hours, instead of 26 hours like it should, because it is not accounting for the dates, just the times. The formula I am using at the moment is =(B1-C1). Help?
Subscribe
  • Post a new comment

    Error

    Comments allowed for members only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 2 comments