Creating a report

I need help with a Report,

I have 6 columns, The order is this:

ID - Employee Name - Supervisor - Supervisor Email - Hour Of leaving - Hour Of Returning

i want to send a report every Hour (Know how to create it) but to send it to each supervisor individually of the persons that didn’t return, how can i send that report for each supervisor? without using this formula [Supervisor]=“Name supervisor”, because there are 67 supervisors and need to do 24 reports (for each hour of the day), all the reports would send the info of persons that didn’t return that pass the hour of leaving + 9 Hours