Transfer Multi-Day Shift Punch to Daily Shift Punches

[OpieWinston]

I need to take multi-day time clock shifts and put it in a new sheet breaking it out per day. So if timeclock shows they worked 3 days straight, I want to break that out to individual day punches. Example sheet is attached.

Thanks for the help!

[JohnTopley]

Please Login or Register  to view this content.

[OpieWinston]

Wow - I have no idea what is going on in that script! Oofda...

Ran the macro and it errored on a row where the time out is NULL. I have no idea how to tweak your macro to account for this as I can't follow along in your script - too advanced for my beginner skills. There are also rows with NULL for the time in as well. Rows with NULL as either the time in or time out can be ignored/skipped since it's not a valid shift for my purposes.

Would you please edit your macro to account for this?

[JohnTopley]

Please post a file with REPRESENTATIVE data as your sample obviously was not: no NULL times!

Ensure expected results are also updated.