LinkBack URL
About LinkBacks
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!
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!
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
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?
Please post a file with REPRESENTATIVE data as your sample obviously was not: no NULL times!
Ensure expected results are also updated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks