Schedule Gap finder Help!

[Benjamin717]

Ok IM getting ready to give up. Mrexcel peeps I need your help. Heres what im trying to accomplish...

I have a list Nurses. This list will also include every state license the nurse has. How can i create an excel worksheet that will let me input the nurses schedules for the month and have the excel sheet show me the details per hour. For example...

7pm- 8pm shows 5 Nurses staffed but only 2 have a California License.

Im completely lost now. If anybody has any advice on this it would be greatly appreciated!

 

[Robert Mika]

Hi Benjamin and welcome to the board.

Could you post an example of your data?

Try to use:

HTML Maker
or
Excel Jenie