Totals

[Robin Lynn Frank]

I use an access database on a FrontPage website where users record the hours
and minutes they devote to a project. This data is kept in 2 columns of an
access table. I need a way to at least total those columns and at best
produce a total where the minutes over 60 are converted to hours.

Any ideas would be appreciated.

 

[Guest]

Hi Robin,

One of these articles should be helpful to you when working with dates:

How to store, calculate, and compare Date/Time data in Microsoft Access
http://support.microsoft.com/?id=210276

How to Calculate Daily Hours Based on Clock In/Clock Out Times
http://support.microsoft.com/?id=237958

On time and how much has elapsed
http://office.microsoft.com/en-us/assistance/HA011102181033.aspx

Using dates and times in Access
http://office.microsoft.com/en-us/assistance/HA010546621033.aspx

Calculate Number of Working Days
http://www.mvps.org/access/datetime/date0006.htm

Doing WorkDay Math in VBA
http://www.mvps.org/access/datetime/date0012.htm


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________