Convert seconds to hours
in [Queries]
|
From: John W. Vinson on 6 Apr 2010 18:54 On Tue, 06 Apr 2010 21:14:26 GMT, "turks67 via AccessMonster.com" <u48755(a)uwe> wrote: >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 [MVP]
From: John W. Vinson on 6 Apr 2010 18:56 On Tue, 06 Apr 2010 22:24:50 GMT, "turks67 via AccessMonster.com" <u48755(a)uwe> wrote: >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") -- John W. Vinson [MVP]
From: turks67 via AccessMonster.com on 6 Apr 2010 19:21
Thank you. John W. Vinson wrote: >>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. -- Message posted via http://www.accessmonster.com |