Hours Subtotal Problem

C

Chipcom

Hi

I am getting a wrong result when I sum up all the hours and I get for
an example 31:59 (31 hours : 59 minutes) , When I need to get is 32:00
Houes.

Is there a problem with the sum function or what?

Thanks
 
T

Tom Wickerath

Is there a problem with the sum function or what?

No, but there likely is a problem with your data, or the data types that you
have chosen (ie. floating point errors). Since you have not provided much
detail, perhaps these articles will be helpful for you:

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

Using Dates and Times in Access
http://office.microsoft.com/en-us/access/HA010546621033.aspx

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

When Microsoft Access Math Doesn't Add Up
http://www.fmsinc.com/tpapers/math/index.html

International Dates in Access
http://allenbrowne.com/ser-36.html

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
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
I

IRS Intern

Warning; Tom Wickerath is a cry baby database pussy and you shouldn't
listen to him for anything

go and talk to someone that knows SQL Server, kids
 
Top