Analysis of Punch Clock Data in new format

Hi Sam,

Try using below formula for time capturing :-

{=IFERROR(INDEX('Original Data'!$C$2:$C$127,SMALL(IF(('Original Data'!$A$2:$A$127='Final Report Format'!$A2)*('Original Data'!$B$2:$B$127='Final Report Format'!$B2),ROW('Original Data'!$C$2:$C$127)-1,""),COLUMN(B$1))),C2)}

now you can tweak your formula for total time to accommodate this.
Punches.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>