Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Macros
- Thread starter jzim9
- Start date
TouchToneTommy
Vendor
Divide the number of seconds by 86400 (the number of seconds in a day);
Format the result as a time.
Format the result as a time.
SkipVought
Programmer
Hi,
Excel Date/Time values are used and stored as days. Hence TTT's suggestion to convert seconds to days. Then FORMAT the result as HH:MM:SS.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
Excel Date/Time values are used and stored as days. Hence TTT's suggestion to convert seconds to days. Then FORMAT the result as HH:MM:SS.
Skip,
[sub]
Just traded in my OLD subtlety...for a NUance!
[/sub]- Status