Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Tom Rettigs Library - timestr(<n seconds>) http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 TIMESTR(<N seconds>)
 Converts seconds to time string.
 Returns <expC> time string in the format "HH:MM:SS".

 Seconds are the "base" unit of time by which all calculations
 can be accurately made and the result converted to minutes,
 hours, days, or another time string.

 Seconds exceeding 1 day are not included.
 They are converted to days with the SSTOD() function.

 * Total seconds exceed one day
 m_seconds = 90000

 days_spent = INT( SSTOD(m_seconds) )
 time_spent = TIMESTR(m_seconds)

 * Total time is days_spent plus time_spent
 * days_spent contains 1
 * time_spent contains "01:00:00"

 * Total seconds do not exceed one day
 m_seconds = 80000

 days_spent = INT( SSTOD(m_seconds) )
 time_spent = TIMESTR(m_seconds)

 * Total time is days_spent plus time_spent
 * days_spent contains 0
 * time_spent contains "22:13:30"


             Placed in the Public Domain by Tom Rettig Assoc.

See Also: ISTSTIME() MAKETIME() TSTOH() TSTOM() TSTOS()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson