Hi,
I'm having trouble working out formulas for a weekly work hours sheet.
Everything was ok untill I added some extra columns to cover Bank Holidays.
If I work a B/H I get 8hrs standard pay, + 8hrs B/H pay, then anything above
that is double time. What I have so far works ok apart from the calculation
for double time.

I have posted a sample below.

http://www.flypicture.com?display=updone&id=rtv3kanb

I know how to remove the minus ( -1 spare cell, copy + paste
special.........) I just can't get the figures right in column "I" as you can
see!!
Any thoughts??
Thx