Converting Time from Seconds

[ASherbuck]

I've got a time clock that stores the current time in seconds in a table.

I'm having a real hard time figuring out how to convert seconds into hh:mm:ss.

For Ex.
"6" = 00:00:06
"67" = 00:01:07
etc

Any ideas? Another thread was mentioning using int() but I don't think that's what I'm looking for.

 

[raskew]

Hi -

Consider that there are 86400 seconds in a day (60 seconds * 60 minutes * 24 hours). So, two ways of doing depending on whether your [number of seconds] are stored as a number or a string (should really be a number, but it can be done if it's a string).

Seconds stored as a number:
x = 6
? format(x/86400, "hh:nn:ss")
00:00:06

Seconds stored as a string:
y = "67"
? format(int/86400, "hh:nn:ss")
00:01:07

HTH - Bob

 

[ASherbuck]

Thanks a bunch, I was using the Format but I had the "hh:mm:ss" wrong

 

[raskew]

Hi -

Glad it worked for you. Might want to check-out this site http://support.microsoft.com/kb/q130514/ to see how Access stores dates/times.

Best Wishes - Bob

P.S.:

"hh:mm:ss"

"mm" represents month month. Use "nn" to represent minutes minutes