Userform Timesheet with Multiple In/Outs

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

did you know that you can add and subtract times? that will avoid the crazy sumifs.

I am fully aware that time can be added and subtracted. The sumifs are there because I needed the data/value moved from a long vertical list to an easy to read grid. So each person can be tracked and making sure all the values line up where they should. Using sumifs was the only way I would figure out how to move it and organize it like that.