Thread: Negative Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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.