In the cell that returns the minutes formatted as [m] use this

=(end-start)*24*60

and format as general or number


Then do your IF formula

otherwise you need to convert the 175 to time which would be H3<175/24/60



one hour
"nlp239" wrote in message
...
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