Attendance Tracker, Add the Hours using codes

Hi,

please help me in getting the total no. of hours using the codes.
See attachment.

Thanks in advance Attendance Tracker.xlsx

Hi,

Check if the attached is helpful.

Thank you Ace_XL and [email protected] for replying. The sumproduct function is really helpful, never knew about it.

Thank you very much! Merry Christmas