Hello All!

I need assistance with a worksheet of teacher clock-in times. I have all the data but the school admins want it in a specific format, to save time in the future I am hoping there is some type of formula that would enable me to connect the dates/times with teacher names.

I have attached the spreadsheet including what I have, and an example of the format they want.

Is this possible?


Thank you! :D

Helpthankyou.xlsx