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...
ChristianMercado If you can guarantee that your time records are clean, it could be as simple as entering the formula below on O2 and copy it down.
=F2+H2+J2+L2+N2-E2-G2-I2-K2-M2However, the date provided includes many records (almost in 60% of them) with "Time IN" but no Time OUT". The opposite occurs as well, though less frequent. How would you handle those cases? None of the time records seem to carry over to the next day (i.e. start before midnight with an end after midnight). Can you confirm that this will indeed never happen?
- yeah, the record isn't clean because they are not taking it seriously.
Thank you very much anyway.
ChristianAs variant
=SUMPRODUCT(($F2:$N2-$E2:$M2)*($F2:$N2>0)*($E2:$M2>0)*ISEVEN(COLUMN(F2:N2)))- Thanks for helping me
