Coffee_in_a_jiffy
New Member
- Joined
- Sep 30, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have a problem I'm trying to solve in Google Sheets. I have a column of employee names; a column with their "clock-in" time; a column with their "clock-out" time. I also have a column with each 1 hour segment of the day in each cell starting "5-6 am" then "6-7 am" and so on.
In the next column I want to be able to count how many employees were on-duty during each 1 hour segment of the work day. Example: "5-6 am" there were 2 employees working; between "6-7 am" there were three employees working, and so on throughout the day.
I have tried using the countif and countifs functions and cannot seem to make this work.
Thank you in advance!
In the next column I want to be able to count how many employees were on-duty during each 1 hour segment of the work day. Example: "5-6 am" there were 2 employees working; between "6-7 am" there were three employees working, and so on throughout the day.
I have tried using the countif and countifs functions and cannot seem to make this work.
Thank you in advance!