Trying to pull employee names from sheet based on time range

RVD1234

New Member
Joined
Jun 6, 2016
Messages
6
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:

EmployeeDateStart TimeEnd Time
Joe Smith7/1/20181020
Ryan James7/1/20181017
Jen Steel7/1/20181317

<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>

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

DateHourEmployeeEmployeeEmployee
7/1/201810Joe SmithRyan James
7/1/201811Joe SmithRyan James
7/1/201812Joe SmithRyan James
7/1/201813Joe SmithRyan JamesJen Steel
7/1/201814Joe SmithRyan JamesJen Steel
7/1/201815Joe SmithRyan JamesJen Steel
7/1/201816Joe SmithRyan JamesJen Steel
7/1/201817Joe SmithRyan JamesJen Steel
7/1/201818Joe Smith
7/1/201819Joe Smith
7/1/201820Joe Smith

<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,214,926
Messages
6,122,305
Members
449,079
Latest member
juggernaut24

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top