Format an Access calculation to display in full 24 hour mode

External Since: Feb 04, 2005 Posts: 1

Doug-

I am having this same problem and you reply sounds very helpful. My problem
is that I am not too familiar with Visual Basic and code. I work in design
view when creating and modifying my databases. Can you tell me how to solve
this problem in design view or give a little more detail as to how I can use
that code in Visual Basic? Thanks in advance.

"Douglas J. Steele" wrote:

> Actually, that won't work George: you're getting 24 hours for each day in
> interval, but you're missing the hours themselves.
>
> Int(CSng(Interval*24)) + Hour(Interval) & ":" & _
> Format(Minute(Interval), "00") & ":" & _
> Format(Second(Interval), "00")
>
> --
> Doug Steele, Microsoft Access MVP
 > <a rel="nofollow" style='text-decoration: none;' href="http://I.Am/DougSteele</font" target="_blank">http://I.Am/DougSteele</font</a>>
> (no e-mails, please!)
>
>
>

 > > One way to get a hh:mm:ss total to display hours greater than 24 in
 > > Access:
 > > Int(CSng(Interval*24)) & ":" & Format(Interval, "nn:ss")
 > > Where Interval is some measure of time (a sum, difference, etc.)
 > >
 > > <a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;210276</font" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;210276</font</a>>
 > > How to store, calculate, and compare Date/Time data in Microsoft Access
 > > (the above is a variation from the "ElapsedTime" function in that article)
 > >
 > > And/or:
 > > <a rel="nofollow" style='text-decoration: none;' href="http://office.microsoft.com/en-us/assistance/HA011102181033.aspx</font" target="_blank">http://office.microsoft.com/en-us/assistance/HA011102181033.aspx</font</a>>
 > > "On time and how much has elapsed"
 > >
 > > HTH,
 > > --
 > > George Nicholson
 > >
 > > Remove 'Junk' from return address.
 > >
 > >

 > >> How can a formula be formatted to display in 24 hours only. Using short
 > >> time
 > >> format when you add up hours in excess of 24 it reverts to day/hour
 > >> format.
 > >> i.e 25 hours 30 min shows as 01:30 (1 day, 1 hour & 30mins). I am using
 > >> the
 > >> database to add up employee hours who are paid on an hourly rate & these
 > >> can
 > >> range from 6 to 50+.
 > >>
 > >> Phil
 > >
 > >
>
>
>

External Since: Feb 08, 2005 Posts: 2

"AccessIM" schreef in bericht

> Doug-
>
> I am having this same problem and you reply sounds very helpful. My
problem
> is that I am not too familiar with Visual Basic and code. I work in
design
> view when creating and modifying my databases. Can you tell me how to
solve
> this problem in design view or give a little more detail as to how I can
use
> that code in Visual Basic? Thanks in advance.
>
> "Douglas J. Steele" wrote:
>
 > > Actually, that won't work George: you're getting 24 hours for each day
in
 > > interval, but you're missing the hours themselves.
 > >
 > > Int(CSng(Interval*24)) + Hour(Interval) & ":" & _
 > > Format(Minute(Interval), "00") & ":" & _
 > > Format(Second(Interval), "00")
 > >
 > > --
 > > Doug Steele, Microsoft Access MVP
 > > <a rel="nofollow" style='text-decoration: none;' href="http://I.Am/DougSteele</font" target="_blank">http://I.Am/DougSteele</font</a>>
 > > (no e-mails, please!)
 > >
 > >
 > >

 > > > One way to get a hh:mm:ss total to display hours greater than 24 in
 > > > Access:
 > > > Int(CSng(Interval*24)) & ":" & Format(Interval, "nn:ss")
 > > > Where Interval is some measure of time (a sum, difference, etc.)
 > > >
 > > > <a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;210276</font" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;210276</font</a>>
 > > > How to store, calculate, and compare Date/Time data in Microsoft
Access
 > > > (the above is a variation from the "ElapsedTime" function in that
article)
 > > >
 > > > And/or:
 > > > <a rel="nofollow" style='text-decoration: none;' href="http://office.microsoft.com/en-us/assistance/HA011102181033.aspx</font" target="_blank">http://office.microsoft.com/en-us/assistance/HA011102181033.aspx</font</a>>
 > > > "On time and how much has elapsed"
 > > >
 > > > HTH,
 > > > --
 > > > George Nicholson
 > > >
 > > > Remove 'Junk' from return address.
 > > >
 > > >

 > > >> How can a formula be formatted to display in 24 hours only. Using
short
 > > >> time
 > > >> format when you add up hours in excess of 24 it reverts to day/hour
 > > >> format.
 > > >> i.e 25 hours 30 min shows as 01:30 (1 day, 1 hour & 30mins). I am
using
 > > >> the
 > > >> database to add up employee hours who are paid on an hourly rate &
these
 > > >> can
 > > >> range from 6 to 50+.
 > > >>
 > > >> Phil
 > > >
 > > >
 > >
 > >
 > >