Home > database >  Sum of values generated by ARRAYFORMULA() is incorrect (Google Sheet)
Sum of values generated by ARRAYFORMULA() is incorrect (Google Sheet)

Time:11-09

I have a sheet used to calculate worked time. The aim is to sum up the hours and divide them in "regular" ones (up to 8h per day) and "overtime" ones (anything more than 8h per day). Each date has to have two rows(the second one is hidden by default), as there are multiple places I can work at, but the time calculated should be summed. Also, time worked on Saturday and Sunday should always be counted as overtime.

enter image description here


update:

=INDEX(SUM(IFERROR(FILTER(1*H3:H71; MOD(ROW(H3:H71)-1; 2)=0); 0)))
  • Related