Getting Incorrect Calculation From Formula
 

I have the below table with the formula's.....can someone pls suggest what
is wrong?

Time In Time Out BT (HR:Mins) Footage Feet Hour Feet Formula Hour
Formula
10:40 11:30 0:50 34 $ 22.10 =IF(E25<=2:00,F25*0.65,"")
=IF(E252:00,F25*20,"")
11:30 11:50 0:20 36 $ 23.40 =IF(E26<=2:00,F26*0.65,"")
=IF(E262:00,F26*20,"")
12:30 13:45 1:15 33 $ 21.45 =IF(E27<=2:00,F27*0.65,"")
=IF(E272:00,F27*20,"")
13:45 14:10 0:25 33 $ 21.45 =IF(E28<=2:00,F28*0.65,"")
=IF(E282:00,F28*20,"")
14:10 15:30 1:20 38 $ 24.70 =IF(E29<=2:00,F29*0.65,"")
=IF(E292:00,F29*20,"")
11:50 14:40 2:50 33 $ 2.36 =IF(E30<=2:00,F30*0.65,"")
=IF(E302:00,F30*20,"")
14:00 15:30 1:30 38 $ 24.70 =IF(E31<=2:00,F31*0.65,"")
=IF(E312:00,F31*20,"")
13:30 13:50 0:20 24 $ 15.60 =IF(E32<=2:00,F32*0.65,"")
=IF(E322:00,F32*20,"")
16:00 18:00 2:00 52 $ 1.67 =IF(E33<=2:00,F33*0.65,"")
=IF(E332:00,F33*20,"")


What's in RED is incorrect........The 2.36, should be $60 and the $1.67
should be blank and the Feet column should have $33.80
This is only a small piece of my data.......

Don

Getting Incorrect Calculation From Formula
 

Are you sure those formulas are doing what you think they're doing?

If I enter this formula in a cell I get an error:

=IF(E25<=2:00,F25*0.65,"")

Try this:

=IF(E25<=TIME(2,0,0),F25*0.65,"")

The 2.36, should be $60

I get 660. 33*20=660

Biff

"Don" wrote in message
...
I have the below table with the formula's.....can someone pls suggest what
is wrong?

Time In Time Out BT (HR:Mins) Footage Feet Hour Feet Formula Hour
Formula
10:40 11:30 0:50 34 $ 22.10 =IF(E25<=2:00,F25*0.65,"")
=IF(E252:00,F25*20,"")
11:30 11:50 0:20 36 $ 23.40 =IF(E26<=2:00,F26*0.65,"")
=IF(E262:00,F26*20,"")
12:30 13:45 1:15 33 $ 21.45 =IF(E27<=2:00,F27*0.65,"")
=IF(E272:00,F27*20,"")
13:45 14:10 0:25 33 $ 21.45 =IF(E28<=2:00,F28*0.65,"")
=IF(E282:00,F28*20,"")
14:10 15:30 1:20 38 $ 24.70 =IF(E29<=2:00,F29*0.65,"")
=IF(E292:00,F29*20,"")
11:50 14:40 2:50 33 $ 2.36 =IF(E30<=2:00,F30*0.65,"")
=IF(E302:00,F30*20,"")
14:00 15:30 1:30 38 $ 24.70 =IF(E31<=2:00,F31*0.65,"")
=IF(E312:00,F31*20,"")
13:30 13:50 0:20 24 $ 15.60 =IF(E32<=2:00,F32*0.65,"")
=IF(E322:00,F32*20,"")
16:00 18:00 2:00 52 $ 1.67 =IF(E33<=2:00,F33*0.65,"")
=IF(E332:00,F33*20,"")


What's in RED is incorrect........The 2.36, should be $60 and the $1.67
should be blank and the Feet column should have $33.80
This is only a small piece of my data.......

Don