I (the manager) need to know how many hours an employee has worked at night. Night hours are e.g. from 22:00 to 06.00.

Also, how many hours an employee has work at holiday night.