Dear All, Is there any possibility to show a time calculation in negative in Excel? Eg: -4.10 hours.
J John Britto Sep 14, 2006 #1 Dear All, Is there any possibility to show a time calculation in negative in Excel? Eg: -4.10 hours.
R Roger Govier Sep 14, 2006 #2 Hi John Use the 1904 date system. Tools>Options>Calculation 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.
Hi John Use the 1904 date system. Tools>Options>Calculation 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.
