A couple of simplifications for your formulae:

In =SUM(G3-F3)*24*60 your SUM function is doing nothing.
Try =(G3-F3)*24*60

In
=IF(H3=0,0,IF(H3<175,(((175-H3)*2)/1440),IF(H3175,((H3-175)/1440),IF(H3=175,0))))
you've got quite a few surplus parentheses
Try
=IF(H3=0,0,IF(H3<175,(175-H3)*2/1440,IF(H3175,(H3-175)/1440,IF(H3=175,0))))
--
David Biddulph

"nlp239" wrote:

Thanks EVERYONE. I tried individual suggestions but couldn't get it to
work - probably because of my own inexperience.
Re-read the explanations and combined your suggestions and it works
great.

Here's what I came up with:

Cell H3 the following: =SUM(G3-F3)*24*60
Cell I3 the following: =IF(H3=0,0,IF(H3<175,(((175-H3)*2)/
1440),IF(H3175,((H3-175)/1440),IF(H3=175,0))))

Thanks again YOUR time and suggestions have helped me a great deal.

On Oct 21, 12:24 am, ShaneDevenshire
wrote:
So the question is what's going on? 175 is the number of minutes that you
see but Excel is storing this as a percentage of the day 175/(60*24) or
175/1440 which is something like 0.121527777777778 even though you don't see
it. Therefore when you write your formula you would need to test with the
decimal number not whole number. Rather than do that its easier to convert
the decimal to actual minutes by multiplying by 1440.

Hope this helps.

--
Thanks,
Shane Devenshire



"nlp239" wrote:
I'm calculating the following:

Start time in hh:mm (F3)
End time in hh:mm (F4)
Total time (F5) this cell is been custom formatted with [m] to convert
to minutes and then calculate penalties.

If F5 is under 175 (minutes) I need to find the difference and
multiply x 2
If over 175 I need to find the difference
If 175 there are no penalties.

I'm using the following formula
=IF(H3=0,0,IF(H3<175,((175-H3)*2),IF(H3175,(H3-175),IF(H3=175,0))))

Why do I get 349.6458333 for a value of 255 in F5

Thanks- Hide quoted text -

- Show quoted text -