Please help total working hours/min??

  • Thread starter Thread starter feretz via AccessMonster.com
  • Start date Start date
F

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.
 
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.
 
Back
Top