J
jinks
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???
two dates?
where is the excelent custom format [h]:mm???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Klatuu
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.
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.
J
jinks
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.
dates, but I can't show it in a pivotchart, because I can't sum the
"showtime", because is a string.
Klatuu said: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.
--
Dave Hargis, Microsoft Access MVP
jinks said: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???
K
Klatuu
then just leave it as a number and don't format it.
--
Dave Hargis, Microsoft Access MVP
--
Dave Hargis, Microsoft Access MVP
jinks said: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.
Klatuu said: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.
--
Dave Hargis, Microsoft Access MVP
jinks said: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???