Hello,

I am trying to create a formula to work out the number of hours between specific times. This is to calculate a shift allowance payment.

Any hours worked between 20:00 and 06:00 will be enhanced by a shift allowance. I need a spreadsheet where the user enters the start and end of their shift, the formula should then work out if this shift qualifies for the allowance and calculate the number of hours to be enhanced:

e.g.

Start: 31/03/2012 22:00
End: 01/04/2012 07:00
Total hours: 9
Enhanced: 8

I haven't used excel for a long time and just cant begin to think how you would do this.
Thanks