View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adnan Adnan is offline
external usenet poster
 
Posts: 59
Default When subtracting dates issue

I have a start date in A1 formatted as dd/mm/yyyy hh:mm
I have another date (finish date) in cell B1 formatted the same (dd/mm/yyyy
hh:mm).
I have a formula in C1 that subtract A1-B1, cell is formatted as dd:hh:mm
It works if results are positive, if negative I get an error, lots of pond
signs within the cell (#########)

Any tip/help is much appreciated.
Adnan