convert number to hrs and seconds

[vangundy]

I have a number field in my Access table, field1. Field1 shows data as seconds.

Field1
3600

I want to convert this to hrs and second so it shows as
1 hr

How can I do this?

 

[PHV]

Something like this ?
Format([Field1/86400, "h \hr n \mi\n s \se\c")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[vangundy]

Perfect thank you!