[<<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()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson