| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Negative Time
I am looking at deviations from an average time (today was 2 minutes faster
than average, yesterday was 3 minutes slower, etc), but excel refuses to display negative times if i simply enter a formula =Today'sTime-AverageTime. I know how to get an absolute difference, but i want the signed (+ or -) time so I can tell fast from slow. Any way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i show negative time in hours minutes | Excel Worksheet Functions | |||
| How do I display time in a negative format? | Excel Worksheet Functions | |||
| How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
| How to show negative time (e.g. -10 hours) | Excel Worksheet Functions | |||
| negative time | Excel Discussion (Misc queries) | |||
Threaded Mode
