With a significant amount of help I had built a timesheet for my staff to use. The calculating data part took a bit and the only way I could find to do it was with overly complicated sumifs formulas. This has been working fine since my company had been paying for my staff's breaks so they only had one sign in/sign out per day. That has since changed and I now need to subtract out their breaks.

What I would like to do is have their in/outs all on one line per staff member per day (see the "Goal" tab) and then calculate out the numbers. What I was attempting to do is add more categories then just IN/OUT and based off that value (Example: LUNCH START/LUNCH STOP) have that determine which column to put the timestamp in pending a name match. I realize I probably need another button for lunch on the userform but wasn't entirely sure how to set up the rest of the code or even if it was possible.

Any help would be greatly appreciated.

Timesheet Template.xlsm