Monkeyboy126
IS-IT--Management
Hi All,
Attached is a spreadsheet I'm working on which is for a Service Desk resources rota. The staff work numerous shifts but I'm interested in counting (on a daily basis) number of people starting before 10.00 and number of people working from 16:00 onwards (columns L and M).
Ideally the formula will ignore null fields.
As always, any help greatly appreciated and I hope I've explained it well enough. I'm using Excel 2010 if that helps.
many thanks
Attached is a spreadsheet I'm working on which is for a Service Desk resources rota. The staff work numerous shifts but I'm interested in counting (on a daily basis) number of people starting before 10.00 and number of people working from 16:00 onwards (columns L and M).
Ideally the formula will ignore null fields.
As always, any help greatly appreciated and I hope I've explained it well enough. I'm using Excel 2010 if that helps.
many thanks