+1 Between Time Ranges

I have a matrix I am working on.

The matrix ranges from 0000-2330 Monday-Sunday (Columns P-V,4-49). I need a formula to get a +1 count for each person working within a time range (Columns D (Start Time) & E (End Time), 1-49) . In addition, I need a dependancy if they are present or not, right now I have a validation column that has 3 categories: Vacation, OOO, Active Duty. If its anything other than Active Duty I have it equaling 0 in a seperate column off to the side.

Excel Example

 

 

By: Ryan

Leave a Reply

Your email address will not be published. Required fields are marked *