Formula Help

[chefmike]

Need help correcting this formula please. using excel 2003.

Col B is start time
Col C is end time
Col D =(C2-B2)*24
Col E =IF(D2<=5,D2,IF(D2>5<10,(D2-0.5),IF(D2>=10,(D2-1.0))))

Works of when the time is less than 5 hours and more than 10 hours, but when
the time is more than 5 and less than 10 the answer is "False"

Please help me fix this error.

Thanks in advance

chefmike

 

[David Biddulph]

=IF(D2<=5,D2,IF(D2>=10,D2-1.0,D2-0.5))

 

[John]

you need to look at the D2>5<10 part. Try
=IF(D2<=5,D2,IF(OR(D2>5,D2<10),(D2-0.5),IF(D2>=10,(D2-1))))
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)