Hello oberon.black,
Excel only tracks time down to a 1 second interval. The decimal portion
of the Time value is the number of seconds from Midnight. There are
86400 seconds in a 24 hour day. The example given is for the worksheet
using coulmn "A". A1 contains the value 0.453240.
EXAMPLE:
'Time in seconds since Midnight
A1 0.453240
'Convert from decimal to integer
A2 =A1*100000
'Calculate Hours
A3 =INT(A2/3600)
'Calculate Minutes
A4 =INT(MOD(A2, 3600)/60)
'Calculate Seconds
A5 =MOD(A2, 3600) - (A4*60)
Sincerly,
Leith Ross
--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=18465
View this thread:
http://www.excelforum.com/showthread.php?threadid=492291