How to calculate the number of working hours each month in a Access query?

[wirejp]

Hi All,

I am using MS Access 2010. I am working out each member of staffs working hours for the month in a MS Access query.

[WorkDate]
[TimeIn]
[TimeOut]
minus a 1 hour lunch.

I would like to display the total hours worked for the month in a hours:minutes format.

I tried this approach: -
Call a field WorkHoursPerMin in a query:-.

WorkHoursPerMin: Sum(DateDiff("n",[timeIn],[timeOut]))

Make a GroupBy query and Sum this field.

For the display I used a second query based on the first where I did the following:

WorkHoursPerMonth: CDate([WorkHoursPerMin]\60 & ":" & [WorkHoursPerMin] Mod 60)

My idea is to show a column with the month of the year and a second with the number of hours worked in that month.

Your help with this is greatly appreciated.

[wirejp]

Hi All,

I got the issue resolved:

1st query: -

WorkHoursPerMin: Sum(DateDiff("n",[timeIn],[timeOut])-60)

2nd query:

WorkMths: [WorkHoursPerMin]\60 & Format([WorkHoursPerMin] Mod 60,"\:00")