convert seconds to timecode format

J

JP

Hi there,

In C1 through to C800 i have values which represent seconds. (time)

HOw can i convert that into
00:00:00:000

hours: mins: secs: fraction of secs

so 3622.411 (secs)
would equal

01:00:22:411

(3600 secs in an hour)

thank you for any help or suggestions.

John
 
C

Cactus [ÏÉÈËÇò]

Try this.

"G7"=3622.411


=INT(G7/3600) & ":" & INT(MOD(G7,3600)/60) & ":" &INT(MOD(G7,36)).....



"JP"
 
R

Roger Govier

Hi JP

Divide your value by 86400 (24 x 60 x 60) as Excel time is stored in
fractions of a day.
Fomat your results cell Format=>Cells=>Custom hh:mm:ss.000
 
Top