Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time in Excel problem :(
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 :( 2) Second problem: How to refresch spreedsheat with this time becouse i would like to see this time ( second after second ) without the manual refresch. Sorry for my language but this is my second language Thank you for your help Best regards Jarek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time in Excel problem :(
Thank you On 20 Pa , 20:49, Ron Rosenfeld wrote: On Sat, 20 Oct 2007 11:24:58 -0700, kicek Excel stores time as days and fractions of a day. So one second = 1/60/60/24 or 0.00001157407407407410 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem selecting only one cell at a time in excel 07 | Excel Discussion (Misc queries) | |||
time problem or excel mistake | Excel Worksheet Functions | |||
Excel Marco Startup Problem: Run-time Error 91 | Excel Programming | |||
Excel static current date/time problem | Excel Worksheet Functions | |||
Excel Date/Time problem | Excel Programming |