Trying to pull employee names from sheet based on time range

I am trying to look at my employee time sheets broken down by date, time, and who was on at the time. My time sheet software give me their clock in and clock out time. I’ve used MROUND to get the closest hour, now I’m struggling to put those names in the correct time slots. This is the data I’ve gotten from our time sheet software:

Employee Date Start Time End Time
Joe Smith 7/1/2018 10 20
Ryan James 7/1/2018 10 17
Jen Steel 7/1/2018 13 17

This is the format I’m trying to get it into:

Date Hour Employee Employee Employee
7/1/2018 10 Joe Smith Ryan James  
7/1/2018 11 Joe Smith Ryan James  
7/1/2018 12 Joe Smith Ryan James  
7/1/2018 13 Joe Smith Ryan James Jen Steel
7/1/2018 14 Joe Smith Ryan James Jen Steel
7/1/2018 15 Joe Smith Ryan James Jen Steel
7/1/2018 16 Joe Smith Ryan James Jen Steel
7/1/2018 17 Joe Smith Ryan James Jen Steel
7/1/2018 18 Joe Smith    
7/1/2018 19 Joe Smith    
7/1/2018 20 Joe Smith    

By: Ian

Leave a Reply

Your email address will not be published. Required fields are marked *