I want to know how many employees were available at a given point of time.
My data: I have an excel which shows my staffing per shift. We have overlapping shifts.
I have mentioned different time slots, I want the count in each time slot should auto populate whenever i fill or change numbers in the shifter. Please see attached.
I cant change the shifter format as it is an automated report.
Thanks in advance!
Ananth