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 ??? Any help would be massively appreciated, and any other details you need, please just let me know :) Thanks, David

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Payroll Sheet Night Hours

Thread starter DavidJohnSevern
Start date Jan 3, 2018
Tags

hours night rate payroll system time wages

DavidJohnSevern

New Member

Jan 3, 2018

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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Shift Start Time[/TD]
[TD]Shift End Time[/TD]
[TD]Start (Date&Time)[/TD]
[TD]End (Date&Time)[/TD]
[TD]Night Rate[/TD]
[/TR]
[TR]
[TD]19:00[/TD]
[TD]08:00[/TD]
[TD]03/01/2018 19:00 [/TD]
[TD]04/01/2018 08:00[/TD]
[TD]???[/TD]
[/TR]
</tbody>[/TABLE]

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