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

You just need to add some parentheses so that the subtraction takes
place before the multiplication, i.e. in I4

=IF(J4="",0,IF(J4=8,(D4-E4)*2))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503873

Thanks very much... I see my mistake now! it is soooooo obvious I'm gonna go
beat my head against the wall.. lol (learning all the time!)

"daddylonglegs" wrote:


You just need to add some parentheses so that the subtraction takes
place before the multiplication, i.e. in I4

=IF(J4="",0,IF(J4=8,(D4-E4)*2))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503873