=if(a1="hi there",INT((D13-C13)*24)+((D14-C14)*24),INT((H14-G13)*24))

This combines the two into a single formula, but I doubt that this is what you
want.

Joe Perez wrote:

Hello,

I want to combine the 2 formulas using the IF function. Each scenario has
its own formula but I want to integrate them into one formula. I'll
appreciate if you could do it for me.

=INT((D13-C13)*24)+((D14-C14)*24)
=INT((H14-G13)*24)

Thanks,

--

Dave Peterson