| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference in time
I have 2 times : 16:20 and 01:02 Trying to find the difference in hours between these times. Used this formula : =(((HOUR(H135-I135)-24)*60)+MINUTE(H135-I135))/60 However the difference comes up as a negetive numbe. I understand the 24 hour clock peice and why this is happening. Is there a way to return the correct number as a positive value of hours between these 2 times? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Difference in Time (Amt. of Time Transpired) | Excel Discussion (Misc queries) | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
Threaded Mode
