convert seconds to timecode format

  • Thread starter Thread starter JP
  • Start date Start date
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
 
Try this.

"G7"=3622.411


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



"JP"
 
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
 
Back
Top