Converting a decimal number into time
Hold on there a second (no pun intended)!
22.4
46.6
111.8
123.8
Need to convert to [ss].00:
:22.40
:46.60
:71.80
:83.80
How does 111.8 relate to :71.80 and 123.8 to :83.80 ?
Biff
"Biff" wrote in message
...
Hi!
Try this:
=TIME(0,0,A1)+MOD(A1,1)/86000
Format as \:[ss].00
Not sure what the backslash is for. Excel adds it automatically.
Biff
"M.A.Tyler" <Great Lakes State wrote in message
...
Would like to convert a decimal number into time. Data is supplied as
follows:
22.4
46.6
111.8
123.8
Need to convert to [ss].00:
:22.40
:46.60
:71.80
:83.80
Is there a formula I can use for this conversion?
Thanks in advance!
|