Convert Seconds

  • Thread starter Thread starter Jessie
  • Start date Start date
J

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
 
Try divide your number of seconds by the number of seconds in a full day
(86400). Then format as time.
 
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.
 
Back
Top