|re: "I cannot find a workbook online that has multiple sign in/sign outs in one day"|
I'm not sure what search terms you used, but I had no problem finding timesheet templates with multiple sign-in times.
One such example:
Description from website:
Timesheet with 2 Breaks
This version allows you to include up to 2 breaks per day (or in other words, 3 separate clock in/out times).
The following page offers step by step instructions for creating your own time card templates, including the required formulas.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.