Total hours (or minutes) in a query

[Ligaya]

Hello,

I have a table wherein the time worked by 25 employees are recorded.
This table has the start time, endtime, break time and late times.
The Late Time is the number of minutes that the employee is late to work.
I am required to do a query of the team's (all 25 staff) late times per month. I have done a query which shows the late times of the individual on the dates that they were late to work and created a crosstab query for that.

I am going around in circles. How can I have a total of the team's late times in a query? Please, could someone please point me in the right direction?

Thank you,
Ligaya

 

[Dennisk]

There was a post a couple of months ago on totaling up times. I thnk the consensus was that you have to write your own which is basically base 60 addition.

 

[Brianwarnock]

This sounds like a simple Total query

for the team, group by Month(datefield) , sum late times, per individual add group by employee to the selection

Brian

AS dennisk has hinted at handling the time values can depend on what you've got and what you want.

 

[Ligaya]

Hello Dennisk and Brianwarnock,

Many thanks to you both for your replies.
My brain cells have atrophied and hopefully will regenerate in the morning when I shall do what you have suggested.

I appreciate your input since I've been floundering so terribly, trying to do the totals for the team.

Thank you.

Regards,
Ligaya

 

[neileg]

Where you want intermediate totals and overall totals, you can't do this in a simple query. However that's exactly the functionality you get in a report.

 

[Ligaya]

'Total hours (or minutes) in a query'‏

Hello Neil,

That's something I have not done before, so I shall certainly give it a go.
Thank you.

Regards,
Ligaya

 

[Dennisk]

I've just performed a simple experiment to sum 10:30 and 12:40 this is 33 hours and 10 minutes. Sum this in a query and each 24 hour period is dropped so the sum is 07:40. The same thing happens if you sum in a report. So its back to base 60 addition