Looking for an IF formula which prints YES if less than 24 hours and NO if more than 24 hours

[JRUBES]

I am fairly novice in Excel… so hopefully someone can help, for I am in need.
I have a =SUM(E7-D7) formula in F column (time formatted) that determines the TIME difference of columns D and E…(both date formatted)
NOW, I am trying to find the formula for the G column that can answer YES if the time length is less than/equal 24 TOTAL hours (24:00:00), and NO if the time is longer/greater than 24 hours.

Is there something that is limiting this calculation? Is Excel viewing this 24:00:00 as an actual time versus a time length? ?
I came up with a couple of formulas, but I am running into issues.

D E F G

[TABLE="align: left"]
<tbody>[TR]
[TD]6/30/13 8:59[/TD]
[TD]6/30/13 16:15[/TD]
[TD]7:16:00[/TD]
[TD] YES/NO[/TD]
[/TR]
[TR]
[TD]6/30/13 15:25[/TD]
[TD]6/30/13 19:18[/TD]
[TD]3:53:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/3/13 19:23[/TD]
[TD]7/4/13 13:26[/TD]
[TD]18:03:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/13 11:23[/TD]
[TD]7/6/13 15:21[/TD]
[TD]3:58:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/13 22:35[/TD]
[TD]7/8/13 7:24[/TD]
[TD]32:49:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/6/13 2250[/TD]
[TD]7/10/13 2250[/TD]
[TD]96:00:00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="align: left"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=IF(F7>TIMEVALUE(“24:00:00”),”NO”,”YES”)
=IF(F7<=TIME(24,0,0),”YES”,”NO”)[/TD]
[TD][/TD]
[TD][/TD]
[TD]


[/TD]
[/TR]
</tbody>[/TABLE]

 

[cyrilbrd]

You are a detailed person! That's the essential quality for being good at Excel!

Thanks for the kind words...