Counting worked hours in a timeslot

To calculate how many hours a person worked within certain time slots in Excel, based on their start and end times, you can use a formula that checks for the overlap between the work hours and your desired time ranges.

Column K: Start time

Column L: End time

M1: Start of your first time range (e.g., 9:00 AM)

M22: End of your first time range (e.g., 12:00 PM)

You want to calculate the overlap between the work hours (from Column K and L) and the time range defined in M1 and M22.

The formula could look like this:

=MAX(0, MIN(L2, M22) - MAX(K2, M1))

My answers are voluntary and without guarantee!

Hope this will help you.