Negative dates and times

  • Thread starter Thread starter Gavyn Milton
  • Start date Start date
G

Gavyn Milton

I need excel to display negative times. At present cells
display #######. Can I change this?

Thanks

Gavyn
 
Hi Gavyn,

I think you have to use the 1904 date system. Go Tools menu > Options...
command > Calculation tab > Select 1904 date system. But, if your workbook
has links to other workbooks that use the default 1900 date system, it could
cause erroneous results.

HTH
 
I need excel to display negative times. At present cells
display #######. Can I change this?
Click to expand...

As a workaround, could you format the cell as a number, absolute value it (or
* -1), then use a special format to show "-" time ? ... or do you need to
calculate with it a bit more ? :)

Bruce
 
Back
Top