Add clock values to report query

[DHookom]

OK, I have tried to figure all this out and have tried some of the solutions without success. Totally my fault. I am going to try and explain again what I need and may find you have already given me the answer at which point I may have to call it a day.

EmployeeID_______EmployeeName________ ClockIn_________________ClockOut______________Hours Worked
__________1_________John Doe__________8/8/2025 8:00AM_________8/8/2025 12:06PM____________4:06
__________1_________John Doe__________8/8/2025 1:00PM__________8/8/2025 5:11PM_____________4:11

I have a query and a form that is working and giving me the above figures but I would like to add the following.

OK, I have employee 1, John Doe. He clocked in for the morning and clocked out for lunch. He clocked back in from lunch and clocked out at end of day. It is easy to look at "Hour Worked" and determine he worked 8 hours and 17 minutes. However, I would like to figure out how to add the, hours worked, 4:06 and 4:11, and show that on the form as the Total Hours Worked. I would like to show this for each employee. Right now, 5 employees to be exact.

For now everyone in the practice will be working basically 8:00AM to 5:30PM, M-F. No overnight, late hours, overtime or weekends.

4:06 and 4:11 are not hours worked. These are both decimal values under the hood that store the amount/part of a day where a day (24 hours) = 1. The value 4:06 is actually stored in your table as 0.170833333333333. Noon has a value of 0.5 while 6:00 AM is 0.25. Your results might be confusing if you expect 4:06 to be greater than 4

 

[BlueSpruce]

OK, I have tried to figure all this out and have tried some of the solutions without success. Totally my fault. I am going to try and explain again what I need and may find you have already given me the answer at which point I may have to call it a day.

EmployeeID_______EmployeeName________ ClockIn_________________ClockOut______________Hours Worked
__________1_________John Doe__________8/8/2025 8:00AM_________8/8/2025 12:06PM____________4:06
__________1_________John Doe__________8/8/2025 1:00PM__________8/8/2025 5:11PM_____________4:11

I have a query and a form that is working and giving me the above figures but I would like to add the following.

OK, I have employee 1, John Doe. He clocked in for the morning and clocked out for lunch. He clocked back in from lunch and clocked out at end of day. It is easy to look at "Hour Worked" and determine he worked 8 hours and 17 minutes. However, I would like to figure out how to add the, hours worked, 4:06 and 4:11, and show that on the form as the Total Hours Worked. I would like to show this for each employee. Right now, 5 employees to be exact.

For now everyone in the practice will be working basically 8:00AM to 5:30PM, M-F. No overnight, late hours, overtime or weekends.

If you post your accdb we can better help you.

 

[Technics]

We understand the requirement. Several approaches suggested.

Post 11 shows two textbox expressions to produce desired results.

On a form, using DSum() expression will result in daily total showing on both lines for each employee.

What exactly did you try and what happened?

I tried to use post 11 but I'm just not sure I know how to use it.