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
 
?

=?gb2312?B?Q2FjdHVzIFvPycjLx/Jd?=

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Convert a decimal time to hours and minutes 2
changing seconds to timecode 2
Convert seconds to hh:mm:ss.dd ? 3
How do I convert seconds (up to 38,000) into HR:MN:SEC? 4
Convert seconds to 00:00:00 (HH:MM:SS) format. Please help 14
i want to convert decimals into time format 3
Converting Seconds into Time Format 3
Convert Decimal Minutes to Hours-Minutes-Seconds 3

Top