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

113 thoughts on “Trying to pull employee names from sheet based on time range

  1. jasa backlink manual

    Howdy, would likely you mind letting us know which web number you’re utilizing? I’ve filled your blog in a few completely different web internet browsers, and I must point out this blog loads substantially faster then most. Can easily you suggest an excellent internet hosting provider at the reasonable price?

  2. produksicetak.com

    My partner and i and my local freinds were going by way of the nice, helpful suggestions coming from the blog then the particular sudden came up along with an awful suspicion I actually never expressed respect for the website owner for all those secrets.

Comments are closed.