DavidJohnSevern
New Member
- Joined
- Jan 3, 2018
- Messages
- 1
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:
<tbody>
</tbody>
Any help would be massively appreciated, and any other details you need, please just let me know
Thanks,
David
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