Calculating Hours

[MichHart]

Hi Guys, i was wondering if you could help me shed some light on the following.

I have a table which details the working hours of an employee for a week.

I have the following fields in the table -

PatternStart
PatternEnds
MonStart
MonEnd
TueStart
TueEnd... etc.

Each day of the week shows a start and end time.

I want to run a report which would calculate the working hours of my employees based on a date range. So when i run my report i would enter a start and end date and it would calculate the working hours of my guys for that period. Is this something access could do for me? Im using Access2003 if that makes any difference.

 

[Phildaburn]

Use of the DateDiff() function will provide you with the number of hours: DateDiff("h",[monstart],[monend]) + DateDiff("h",[TueStart],[TueEnd]) + etc. I'm curious why you have the days of the week in separate fields. A date calculation can tell you what day of the week the activity occurred on.

Phil...

 

[MichHart]

Hi Phil, thanks for getting back to me.

Ive split the days down in such away because the team work different shifts and id like to keep track on them. I do think i may be over egging the cake slightly in doing so though...

I'll give you suggestion a try as soon as i can.