Please help total working hours/min??

[feretz via AccessMonster.com]

Hi There,

using Access how would i go about creating a query that will sum up the
total hours worked over a working week.

Here is an example of what i would like it to do.
..........mon..... tues..... wed..... thur..... fri..... sat..... sun
Hrs worked 7.30.... 16.00.... d/off.... 7.30..... d/o.. ..11.30... 11.30

the problem i am getting is that i can't get the correct total Hrs:Min due
to the 24hr and the 60min factor because the toltal hours worked is over
24hr

I would be realy greatful if someone could help me with this problem.

Many thanks to anybody who will take time to point me in the right
direction.

 

[Rick B]

As posted many times. Time (hours and minutes) is used for a particular
point in time. (it is 4:02 on Tuesday).
Duration is used to record elapsed time. (it took me six and a halkf hours
to complete that task).

You can't store durations in a TIME field. You need to either store them in
a NUMBER field such as 8.5 to represent 8 hours and 30 minutes. This allows
math to be performed. If you want to calculate pay, you can multiply an
hourly rate (say $15.00) by the answer (say 39.5 hours) and end up with the
pay. You can't mutiply by 39:30.

Or, you could use two number fields if you insist on using hours and
minutes. Each field would be a number. One would be the number of hours.
The other would be the number of minutes. Doing it this way adds a great
deal of complexity and logic to the whole thing.