View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kicek kicek is offline
external usenet poster
 
Posts: 9
Default 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