| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
