Need help adding another condition to IF formula

We are dealing with times and number of hours here.

Here is what I have in cell I2
=IF(F2="",0,(IF((($G2-$F2)*1440)/60<=0,((($G2-$F2)*1440)/60)+24,(($G2-$F2)*1440)/60))-0.5)

However, if G2-F2 is less than E2-D2, then I don't want the -0.5 at the end.

Here's an example
D2 E2 F2 G2 H2 I2
8:00 18:30 15:30 18:30 CU 2.50

In that example, G2-F2 is less than E2-D2. With the formula the way it is, I get 2.50 hours in I2. Since G2-F2 is less than E2-D2, my answer in I2 needs to be 3.00 hours. Everything I do is messing things up and I get the warning that says there is an error in my formula. Please help.

Originally Posted by Ron Coderre

Maybe this...

Formula:

Please Login or Register  to view this content.

Does that do what you want?

No. That gives me #VALUE! .

Book3.xlsm

Sorry, here is spreadsheet I am working with.

Monday morning check for new replies. Any help will be appreciated.