Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding Time difference
I know this has to be easy. I have a start time and an end time. I need the
difference in hours and minutes. I used the examples in the help, but it converts it to text and then it won't add. Anyone? TIA JC |
#2
|
|||
|
|||
One way:
A1: <start time B1: <end time C1: =B1-A1 format C1 as time. XL stores times as fractional days (e.g., 3:00 = 0.125), so if your times span midnight, the "later" time will be smaller than the "earlier" time. Compensate that by adding 1 to the "end time". You can take advantage of XL's automatic coercion of boolean TRUE/FALSE values to 1/0: =(B1<A1) + B1 - A1 or the more obscure, but equivalent: =MOD(B1-A1, 1) In article , "John Harris" wrote: I know this has to be easy. I have a start time and an end time. I need the difference in hours and minutes. I used the examples in the help, but it converts it to text and then it won't add. Anyone? |
#3
|
|||
|
|||
One more version that might be even more clear:
=B1-A1+IF(B1<A1,1,0) Still following JE's rules: A1: <start time B1: <end time John Harris wrote: I know this has to be easy. I have a start time and an end time. I need the difference in hours and minutes. I used the examples in the help, but it converts it to text and then it won't add. Anyone? TIA JC -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate time difference to the half hour | Excel Worksheet Functions | |||
Time zone Time difference | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Time / Formula to look at time difference | Excel Worksheet Functions |