Payroll Sheet Night Hours

[DavidJohnSevern]

Hi!

I'm currently making a new payroll sheet for work, and I've got stuck at working out night rate! Employees get paid night rate between 20:00 - 06:00 and I'm trying to get the formula to work out night rate in a single cell.

The layout I have to far is:

Shift Start Time	Shift End Time	Start (Date&Time)	End (Date&Time)	Night Rate
19:00	08:00	03/01/2018 19:00	04/01/2018 08:00	???

<tbody>
</tbody>

Any help would be massively appreciated, and any other details you need, please just let me know

Thanks,
David