Calculate dates/times using If Statements?

I'm not too hot with Excel formulas but I'll explain as best I can....hopefully someone can help

I have 3 columns with dates and times

A - 01/08/2008 08:17:08
B - 01/08/2008 12:17:08
C - 01/08/2008 17:00:11

This is what I want to do...

If A > B then Calculate the time difference between A and C
If A <= B then Calculate time difference from B to C

I'd like to get this formula in 1 cell if possible?

Thanks in advance. Roper99

Welcome to the forum.

Maybe =IF(A1 > B1, ABS(A1-B1), ABS(B1-C1)) and format the result as [h]:mm

Hi,

Try this

=IF(A1>B1,C1-A1,IF(A1<=B1,C1-B1,"")) and format the result as [h]:mm