Converting seconds to hours/minutes/seconds

[Roger]

I need to take a number such as 1800seconds and convert to
01:00:00am, any suggestions

 

[Max]

Maybe one way ..

If in A1: 1800 (figs in seconds)
put in B1: =A1/(60*60*24)
custom format B1 as: h:mm:ss AM/PM

B1 will show as: 12:30:00 AM

Think your post's > 01:00:00am is incorrect,
as 1800 sec = 0.5 hour, not 1 hour

 

[roger]

Tks Max, so simple so hard

-----Original Message-----
Maybe one way ..

If in A1: 1800 (figs in seconds)
put in B1: =A1/(60*60*24)
custom format B1 as: h:mm:ss AM/PM

B1 will show as: 12:30:00 AM

Think your post's > 01:00:00am is incorrect,
as 1800 sec = 0.5 hour, not 1 hour

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----



.

 

[Max]

Tks Max, so simple so hard

You're welcome, Roger!
Thanks for the feedback

Once you get the hang of it,
it won't be so tough <g>