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?
Printable View
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?
field1 / 60 / 60 = 1
VB Code:
msgbox timeserial(0,0,3600)
gives you 1:00:00 AM
even in WORD
VBA Code : format(<number>,"hh:nn:ss")