Compare time (May be Index & Match function)

[ABC10]

Hello,
I need some help.
Sheet one has Event happened data. In Sheet 2 I have to calculate Event by HE and Event Minutes per HE. I did calculate using IF function but still I have to change cell position. Here I uploaded workbook.

As example:
Sheet 1: 4-Aug -event start time is 13:33 :00 and time off 19:07:00.(event duration was 5 hours 34 minutes; total 327 minutes)
Sheet 2: Column A has 24hrs break down(basically 24 row for each date).
I need formula that automatically note event by Hour and Event minutes per hours.(I did formula for N column but still I need to change cell manually- I need more automation)
Please, give me guideline

Thanks,