How to use custom format [h]:mm like in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jinks - 31 Oct 2007 15:32 GMT

How can I show a form in pivochart view summing the hours that passed between
two dates?

where is the excelent custom format [h]:mm???

Reply to this Message

Klatuu - 31 Oct 2007 15:44 GMT

In Access, you have to do it yourself. First you need to use the DateDiff
function to get the number of minutes.

lngHrsAndMins = DateDiff("n",StartTime, EndTime)

Then you have to separate the hours and minutes.

strShowTime = Format(lngHrsAndMins \ 60, "00\:") & Format(lngHrsAndMins Mod
60, "00")

the \ divisor returns on the integer part and gives you the number of hours.
the Mod operator returns only the remainder part and gives you the number of
minutes.

Signature

Dave Hargis, Microsoft Access MVP

> How can I show a form in pivochart view summing the hours that passed between
> two dates?
>
> where is the excelent custom format [h]:mm???

Reply to this Message

jinks - 31 Oct 2007 16:39 GMT

When I do that I can obtain in a query the difference in hours between two
dates, but I can't show it in a pivotchart, because I can't sum the
"showtime", because is a string.

> In Access, you have to do it yourself. First you need to use the DateDiff
> function to get the number of minutes.
[quoted text clipped - 14 lines]
> >
> > where is the excelent custom format [h]:mm???

Reply to this Message

Klatuu - 31 Oct 2007 16:43 GMT

then just leave it as a number and don't format it.

Signature

Dave Hargis, Microsoft Access MVP

> When I do that I can obtain in a query the difference in hours between two
> dates, but I can't show it in a pivotchart, because I can't sum the
[quoted text clipped - 18 lines]
> > >
> > > where is the excelent custom format [h]:mm???

Reply to this Message