Hi everyone,
I want to calculate an automated breakdown of the total number of people working at any given time throughout the day when I have only their SOS (Start Of Shift) and EOS (End Of Shift) times, as well as total hours worked. So for a very basic example if I have one person working 1200-1800, another 1100-1900 and someone else 0900-1500 how many total people are working at 1600? Is there a way to calculate this using Excel?
Thanks in advance I appreciate any help!
I want to calculate an automated breakdown of the total number of people working at any given time throughout the day when I have only their SOS (Start Of Shift) and EOS (End Of Shift) times, as well as total hours worked. So for a very basic example if I have one person working 1200-1800, another 1100-1900 and someone else 0900-1500 how many total people are working at 1600? Is there a way to calculate this using Excel?
Thanks in advance I appreciate any help!