| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formula (difference of predicted and actual time)
I have a time formula in my spreedsheet. It is to calculate the difference
in a predicted time with the actual time. Time is entered as text eg. 14:00. My formula is =TEXT(A4-H4,"H:MM") OR =TEXT(predicted time - actual time, "H:MM") The formula works great if the actual time is prior to or equal to the predicted time. However I cannot get a result for the time if the actual time is later than the predicted time. I need the result to be -h,mm. If you can help me accomplish this I would really appriceate it. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| How to sync my received time with the actual time? | Excel Discussion (Misc queries) | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Threaded Mode
