R
Roger
I need to take a number such as 1800seconds and convert to
01:00:00am, any suggestions
01:00:00am, any suggestions
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
R
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
----
.
M
Max
roger said: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>