Forum Discussion
Calculating Total hours worked
Good day, I'm looking for a formula that can get total hours worked per person given that there are multiple INs, and OUTs because of break time. attached is the daily time record for the mon...
yeah, the record isn't clean because they are not taking it seriously.
Thank you very much anyway.
Christian
Thank you very much anyway.
Christian
As variant
=SUMPRODUCT(($F2:$N2-$E2:$M2)*($F2:$N2>0)*($E2:$M2>0)*ISEVEN(COLUMN(F2:N2)))
- Thanks for helping me