View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deepak Deepak is offline
external usenet poster
 
Posts: 47
Default To Display Negative Dates

Hello !

Thanks to all you for helping out me in my previous problem. This i have a
problem with diplaying negative times,

Say A1= 10:30 (format is hh:mm) and B1 = 8:30 (format is hh:mm).
when C1=B1-A1, the value is displayed as ##### with notification negative
dates and times are displayed as ######.
Is there a way to display the negative time (for e.g. 8:30 - 10:30 = -2:00)

Thanks