Thread: is 0.000000000000000055511151231258=0 in excell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christian Weller Christian Weller is offline
external usenet poster
  
Posts: 1
Default is 0.000000000000000055511151231258=0 in excell?
In excel I am calculating the time difference between two times
I.e. 6:17:36 AM - 6:17:36 AM = 00:00:00 (12:00:00 am depending on formatting)
Sometimes I get 0 , but often get =0.000000000000000055511151231258 or
-0.000000000000000055511151231258 (number format with 30 decimal places)

Any ideas why?


Reply With QuoteReply With Quote