Thread: is 0.000000000000000055511151231258=0 in excell?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
  
Posts: 690
Default is 0.000000000000000055511151231258=0 in excell?
but often get =0.000000000000000055511151231258

Another way to say the same thing as the others...

=POWER(2,-54)
0.000000000000000055511151231258

= = = = =
Dana DeLouis



Christian Weller wrote:
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