Total Time spent video is if you only have one in and one out, and you need to automatically exclude time in the middle (like lunch).

If you have all the ins/outs you don't need anything that advanced.

Try these
Employee Time Clock
Timesheets

Edit: I see in the normal video before the extended cut, he does do a little bit with the timeclock in the time spent video, you could do it like that. If you were doing it by employee instead of job, you would use like an employeeID instead of the jobID.

How to total daily time/weekly time per employee.

I have the one Richard shows how to do, but it totals everything.
I hope it's an easy fix.
Thank you.

You need to add criteria. If you're making it in a query, make the first/last names filter to whoever your looking for in the criteria tab.

Thats one way you could do it, it would be easier if you made a combo box with all your names in it and made the criteria =Forms!YourFormName!YourComboBoxName and run the query from there, then you wouldn't have to manually type in names.

I thought I am already doing that, unless I missed something.

OH sorry I thought your question was how to split it per employee. If you want the total, just use an Aggregate Query on it and SUM the time.

I would like to add 7/18/2024 8:01 am-7/18/2024 12:58 pm =4 hours 57 min
                           7/18/2024 1:32 pm-7/18/2024 5:12 pm   =3 hours 40 min
for that day, then do the same thing for the rest of the week.
Will an aggregate query do this?
Thank you.

For each employee in the database. (12)

With some changes yea, you're going to need DateValue as well. Group By Name, Group By the DateValue of your dates, and sum the total time

Something like that, you can filter specific dates and names in the criteria. Note this method only takes the date from the time in, if you crossed days in your clock ins/outs you may need to do more.

Here are some screen shots of what I am attempting to do:

First Screenshot: Is the source Query with the needed columns,
Second Screenshot : Is my Named Query with the clock in and clock out times for that day,
Third Screenshot: is what I would like to have totaled by the Access Query.

I have tried to do this using the time sheets video, but it totals everyrthing. Is there a way to total the Display Time or what ever it would need to called for just that day and then do it for all other time in and time out for the week, and for all 12 employees?
I really don't want to be a bother, but I would like to understand this better. Maybe I missed a particular video?
Thank you, as always.

There are 11 more employees in this form. I didn't want to show their names.

Add a Combo Box to the Form Header to select the employee. Use an After Update event to filter the results on the Form based on the selected employee.

Richard, I need help with this, if you could.
Thank you.

Did you do the Filter like Kevin suggested? You have the time worked already, you just need to filter it to an employee.

Filter Combo
Filter Records

What I would really like to do is get a total of hours worked for each employee in the continuous form that Richard shows how to build, but for each employee,  not a grand total for all employees. I just don't know how to do it, or I missed something.
my form works great, i just don't want a Grand Total O f Hours. I hope that is possible.
It can be done in Excel, but I would rather use Access!
Thank you so much.

Ok so to confirm, you want a sum of the total minutes per employee, you don't care about per day, just per employee. You can do that with an Aggregate Query doing group on your employee and sum on the total minutes field.

If you need more fields you might have to do it in 2 queries or a union query, but with only bringing in those 2 fields it will work

Using my last image i shared aboveThat would return

John-720
Tim-60

If thats not it, share an image what your trying to do in excel and we can tell you how to do it on access.

This is what I would like to do, but in access. Like Richards example in the time sheets video, but totaling individule employees not the grand total. I just cant figure out how to do this in a query or other wise.
I really appreciate you all for tollerating me.
Thank you.

=((F2-C2)-(E2-D2))*24 =Hours Worked
=H2-8 = Overtime Hours Worked
=SUM(H2+I2) =Total Combined Hours Worked

The Excel example I've shown would be extrapolated out for 5 - 6 days, then for each employee.

I'm sorry for bothering you all.