Adding hour/minute time in MS Access

[George]

Hello........I have a problem adding up record entries with more than 24
hours when the fields are formatted as hour/minute (h:m). If the actual
summed total of all records is greater than 24 hours, then the hour part of
the answer is truncated to a number less than 24 based on however many
multiples of 24 were part of the summed answer (clear as mud?).
I anticipate the soulution involves either formatting the time field in a
manner that allows more than 24 hours to be displayed or being able to
convert the inputted h:m times into decimal numbers before any summing takes
place.
Can anyone point me towards a simple solution to this problem.
.........Thank you.

[Bob Quintal]

Re: Adding hour/minute time in MS Access

"George" <george@handy.p air.comwrote in
news:mvhyj.6619 $Mh2.5681@nlpi0 69.nbdc.sbc.com :

Hello........I have a problem adding up record entries with more
than 24 hours when the fields are formatted as hour/minute (h:m).
If the actual summed total of all records is greater than 24
hours, then the hour part of the answer is truncated to a number
less than 24 based on however many multiples of 24 were part of
the summed answer (clear as mud?). I anticipate the soulution
involves either formatting the time field in a manner that allows
more than 24 hours to be displayed or being able to convert the
inputted h:m times into decimal numbers before any summing takes
place.
Can anyone point me towards a simple solution to this problem.
........Thank you.
>

Dates and times are stored in Access as (# of days since
12/12/1899).(fraction of one day).If you have not stored the day
portion of the date, you can sum the numbers underlying the hh:mm
format, then use a self-written function to get the days as
cint(SumOftimes ) and show that as well as the time.

If you have stored the data and are just not showing it, usse the
datediff() function to get the number of minutes, then convert
minutes to days:hours:minu tes using a different function such as the
sec2Dur() function I posted on this list a couple of years ago.
Google finds it readily.




--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com