View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Time in Excel problem :(

On Sat, 20 Oct 2007 11:24:58 -0700, kicek
wrote:

Dear all,

I kindly ask you for help with Excel.

1)
I have a formula with actual time and i see the number of this time as
digits.
for example : Time :"20:18:57" and represented of this time digits
"39375,8464964120000"
i need to know the delta ( change od digits ) based on 1 second ( This
is very difficult becouse i need to be sure that one second is for
eample 0,000045. I can not find this information in google :(


Excel stores time as days and fractions of a day. So one second = 1/60/60/24
or 0.00001157407407407410


--ron