| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Time
Dear All,
Is there any possibility to show a time calculation in negative in Excel? Eg: -4.10 hours. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Time
Hi John
Use the 1904 date system. ToolsOptionsCalculation and tick 1904 system Beware though, if you have other data calculations set up as the base date varies by 4 years and 1 day (I think!) from the 1900 date system. -- Regards Roger Govier "John Britto" wrote in message ... Dear All, Is there any possibility to show a time calculation in negative in Excel? Eg: -4.10 hours. |
| Reply |
| 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) | |||
Linear Mode
