Seconds to hrs, min, sec

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table containing seconds (the time kind of seconds) formatted as
number
Can I convert that to hrs, min, seconds in a query? If so, how and can I do
that?

Thank you.
 
Wylie said:
I have a table containing seconds (the time kind of seconds) formatted as
number
Can I convert that to hrs, min, seconds in a query? If so, how and can I do
that?
Click to expand...


hrs = seconds \ 3600
min = (seconds Mod 3600) \ 60
secs = seconds Mod 60
 
Back
Top