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...
Hi ChristianMercado,
This array formula might be helpful, but only criteria is you must have both In & out date, any one of them is missing then it will consider it as zero. as rightly said by Riny_van_Eekelen your time records are must be clean.
- Copy the below formula
- Paste in the cell & press ctrl + shift + enter
=SUM(IFERROR(TIMEVALUE(IF(SEARCH("Out",$F$1:$N$1),F2:N2))-TIMEVALUE(IF(SEARCH("In",$E$1:$M$1),E2:M2)),0))
Please see the attached file with the formula
Regards, Faraz Shaikh, MCT, MIE, MOS Master, Excel Expert