Convert Seconds

[Jessie]

Hello.

I Have a field in my table that represents seconds worked.

Now we have a client that won't accept the log in seconds
they want it formatted:

hh:mm:ss

is there a way to make access convert the seconds into
this format?

Thanks,
Jessie

 

[Duane Hookom]

Try divide your number of seconds by the number of seconds in a full day
(86400). Then format as time.

 

[Van T. Dinh]

Format$([Secs] \ 3600, "00") & ":" &
Format$(([Secs] MOD 3600) \ 60, "00") & ":" &
Format$([Secs] MOD 60, "00")

wil give yo the Text String that represent the [Secs] in hh:mm:ss format.