software

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.

www.flypicture.com?display=updoneamp;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 quot;Iquot; 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=quot;quot;,0,IF(J4=8,(D4-E4)*2))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=503873Thanks 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!)

quot;daddylonglegsquot; wrote:

gt;
gt; You just need to add some parentheses so that the subtraction takes
gt; place before the multiplication, i.e. in I4
gt;
gt; =IF(J4=quot;quot;,0,IF(J4=8,(D4-E4)*2))
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=503873
gt;
gt;