convert seconds into hh:mm:ss

[robsuttonjr]

What is the simplest code to convert seconds into hh:mm:ss format?

 

[chpicker]

Try this:
[tt]
nSeconds=16000
SET SECONDS ON
?TTOC({^2000-1-1,00:00:00}+nSeconds,2)
[/tt]
This will output:
[tt]
04:26:40
[/tt]
Hope that helps,

Ian

 

[robsuttonjr]

It won't work for any seconds that exceed a days worth. If you pass more than 86400 seconds using the datetime method, the time flips back to midnight. There must be an easier way.

 

[robsuttonjr]

Here is what I used:

ALLTRIM(STR(INT(SUM(b.Csrlogouttime-b.Csrlogintime)/3600)))+":"+ALLTRIM(STR(INT(MOD(SUM(b.Csrlogouttime-b.Csrlogintime),3600)/60)))+":"+ALLTRIM(STR(INT(MOD(SUM(b.Csrlogouttime-b.Csrlogintime),60))))

 

[dgrewe]

Here is an old 2.6 routine I wrote before the days of the date:time field commands in VFP. The routine will return time in either 12 or 24 hour format depending on a parameter you pass it.

http://ibs.internationalbid.net/home/dave/code_html/tm_s2t.html

David W. Grewe
Dave@internationalbid.com