Change to the 1904 date system

ToolsOptionsCalculation, and check the 1904 date system.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Amr Shehata" <Amr wrote in message
...
I have two cells that carry two different times as follow
cell A1 has 00:05:00
cell A2 has 00:04:00
cell A3 should display the difference in negative way(-00:01:00). I only
get
##### instead of the answer in cell A3 and a message reads (negative dates
or
times are displayed as # # # #) Your help will much appricated. thanks