LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem selecting only one cell at a time in excel 07 rot Excel Discussion (Misc queries) 0 July 2nd 08 08:40 AM
time problem or excel mistake engin Excel Worksheet Functions 1 January 11th 06 10:46 PM
Excel Marco Startup Problem: Run-time Error 91 [email protected] Excel Programming 3 December 15th 05 07:46 PM
Excel static current date/time problem hpmted Excel Worksheet Functions 1 March 30th 05 09:12 PM
Excel Date/Time problem Demian Valle Excel Programming 1 August 3rd 04 03:09 AM


All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"