Convert seconds to hours
in [Queries]
|
From: turks67 via AccessMonster.com on 6 Apr 2010 17:14 How do I convert (226942) seconds to hours? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1
From: Jeff Boyce on 6 Apr 2010 17:36 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" <u48755(a)uwe> wrote in message news:a6248598b2bd9(a)uwe... > How do I convert (226942) seconds to hours? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1 >
From: turks67 via AccessMonster.com on 6 Apr 2010 17:57 I'm trying to do this in a query.What if the number of hours are over 24. Jeff Boyce wrote: >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 > >> How do I convert (226942) seconds to hours? -- Message posted via http://www.accessmonster.com
From: KARL DEWEY on 6 Apr 2010 18:05 Divide by (60 * 60) -- Build a little, test a little. "turks67 via AccessMonster.com" wrote: > How do I convert (226942) seconds to hours? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1 > > . >
From: turks67 via AccessMonster.com on 6 Apr 2010 18:24
What I'm I doing wrong? It's only giving me 15:02 hours. KARL DEWEY wrote: >Divide by (60 * 60) > >> How do I convert (226942) seconds to hours? -- Message posted via http://www.accessmonster.com |