L
Lene Hansen
I need to make a format that can subtract hours AND show negative hours.
Can anyone help?
Can anyone help?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
a format can't change values
a format can't change values
M
Myrna Larson
Excel can only display negative time if you switch to the 1904 date system
(Tools/Options/Calculation). If you do that, all of your dates will be "off"
by 1462 days, so you'll have to subtract the number 1462 from them. If you
need to do that, type the number 1462 in a cell somewhere. Edit/Copy that
cell. Then select the cells with the dates (hopefully they are all in a one or
two columns), then Edit/Paste Special, and select the Values and Subtract
options.
It's best (obviously) to set the date system before you start entering data.
On Mon, 27 Sep 2004 02:57:03 -0700, "Lene Hansen" <Lene
(Tools/Options/Calculation). If you do that, all of your dates will be "off"
by 1462 days, so you'll have to subtract the number 1462 from them. If you
need to do that, type the number 1462 in a cell somewhere. Edit/Copy that
cell. Then select the cells with the dates (hopefully they are all in a one or
two columns), then Edit/Paste Special, and select the Values and Subtract
options.
It's best (obviously) to set the date system before you start entering data.
On Mon, 27 Sep 2004 02:57:03 -0700, "Lene Hansen" <Lene
D
David McRitchie
Hi Lene,
The 1904 date option (on or off) applies to the entire workbook.
Actually being under the topic "workbook options" within
the calculation tab, it is one of the few options that actually
indicates the scope.
The 1904 date option (on or off) applies to the entire workbook.
Actually being under the topic "workbook options" within
the calculation tab, it is one of the few options that actually
indicates the scope.