If/Then Statement help

[bridgeb3]

I have a table with 3 columns (Appt Time, Arrival Time, & Late). The
columns are all time format. I need the late column to only show a
time IF the arrival time is after the appt time. So IF D2-C2>0 I want
it to do that formula and put it in the column, but leave it blank if
not. I am not sure how to correctly make this statement. All help is
appreciated!

Barry

 

[tim m]

Give this a shot.

=IF(D2-C2>0,D2-C2," ")

 

[JE McGimpsey]

One way:

E2: =IF(MOD(D2-C2,1)>0,MOD(D2-C2,1),"")

 

[JE McGimpsey]

Note:

This will work unless the times may span midnight (due to XL storing
times as fractional days).

Also, there's no reason to include a space character between the quote
marks if the value's <=0.