View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Amr Shehata Amr Shehata is offline
external usenet poster
 
Posts: 3
Default negative dates or times are displayed as # # # #

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 be much appricated. thanks