Negative Time
 

Dear All,

Is there any possibility to show a time calculation in negative in Excel? Eg:
-4.10 hours.

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.