Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a table in Excel where I save an input time of a query and the output time of the query - i.e. when I receive it and when I handle it.

I want to calculate the my response time. What is the right formula?

share|improve this question
    
How are your input and output times formatted? –  Excellll Jun 30 '11 at 16:51
add comment

1 Answer

As long as you have the two times entered in cells as proper Excel datetimes then you can simply subtract the starting datetime from the ending datetime.

If starting time is in cell A1 and ending time is in cell B1 then you can calculate difference in C1 with:

=B1-A1

Excel datetimes are represented as the real numbers with 1 being 01-01-1900.

Depending on your typical response time, you might choose to format the result as hh:mm:ss or as fractions of days. You can use inbuilt and custom number formats to achieve the result you want.

Note: If you do not enter the starting and ending time in a format that Excel understands as datetimes then they will be treated as text and you won't be able to apply the formula I have shown.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.