Okay, I've searched - the words "timestamp", "work" and "shift" return way to much to sift through, so I'll start a new thread. Apologies.
I have a data file that I import into Excel (2007). It gives me a time stamp on each transaction, along with user names, and the transaction details. I need to 'lump' these into the activity performed by each shift. (there are three, from 9pm to 5am, 5am to 1pm, and 1pm to 9pm).
So, simply stated, did each transaction occur on shift 1, 2, or 3?
This task is to help management even out workloads across the shifts, and determine peak activities - which I can get to with pivot tables, etc after I've identified the shift. (Since 3rd shift spans two days, the if "window" might be: 9p to midnight, and midnight to 5a ?)
sample file attached. Staff names deleted.
any and all help sincerely appreciated !!!
Refill Activity Shift Test.xlsx
Bookmarks