Formula

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!...