Hi. I am designing a new staff rota and need to calculate hours and minutes from a selection of dates for the whole year. When I use the formula =SUMIF(F3:F563,">0")/60 this does exactly what want for the whole but I cannot work out how to show a subtotal when I filter the list to show a range...