Convert seconds to hours

[turks67 via AccessMonster.com]

How do I convert (226942) seconds to hours?

 

[Jeff Boyce]

How many seconds are in one hour?

Divide your number by that number.

Where are you trying to do this?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[turks67 via AccessMonster.com]

I'm trying to do this in a query.What if the number of hours are over 24.

 

[KARL DEWEY]

Divide by (60 * 60)

 

[turks67 via AccessMonster.com]

What I'm I doing wrong? It's only giving me 15:02 hours.

 

[John W. Vinson]

How do I convert (226942) seconds to hours?

Divide by 3600: 226942/3600 = 63.0394444444 hours.

If that's not the answer you want please explain.

 

[John W. Vinson]

What I'm I doing wrong? It's only giving me 15:02 hours.

You're formatting it as a date/time instead of as a number.

You asked for hours. You didn't ask for hours <colon> minutes date/time
format!

If that's what you want, try

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

 

[turks67 via AccessMonster.com]

Thank you.

Divide by 3600: 226942/3600 = 63.0394444444 hours.

If that's not the answer you want please explain.