Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I show number of hours as a negative using formula?
hi,
what format are you using now? ####### could also mean that the column is not wide enough. -----Original 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 | |||
Sum - show negative number? | Excel Discussion (Misc queries) | |||
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 |