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.
|