Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I show number of hours as a negative using formula?
The default date system for windows, 1900 date system, does not support
negative time. Perhaps you can multiply your result by 24 and show it as an integer or decimal -- Regards, Tom Ogilvy "GBH99" wrote in message ... I am having trouble formatting a cell so that when the number of hours someone has completed for work against what they should have worked can show as a negative value instead of #############################. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i show negative time in hours minutes | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
How to show negative time (e.g. -10 hours) | Excel Worksheet Functions | |||
How can I show hours of more than 24 & negative hours? | Excel Worksheet Functions | |||
How do I show number of hours as a negative using formula? | Excel Programming |