Hi there
Is there someone that can help me with a rota spreadsheet and calculating the number of hours a day (over a month) please?
I have a formula
=SUMPRODUCT(($B7:$B35=ShiftNames)*(Shifts!$D$3:$D$27))
but it's faulting somewhere in the formula, I can't figure it out
I can send a screenshot of what the rota looks like or if easier I can send over a copy of the rota???
Thanks in advance
Natasha