"George" <ge****@handy.pair.comwrote in
news:mv*****************@nlpi069.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:minutes 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