Need help - define within 24 hours

[tracy702]

How do I write a formula to give me a False/True if the call was closed within 24 hours?

Columns
A - Create Date
B - Start Call Time
C - Close Date
D - End Call Time
E - Owner
F - Same Day (I have =A=C and it's the false's that I now have to filter if they are within 24 hours)
G - will be the false/true or yes/no colum

screenshot.jpg

[mrice]

Try

=IF((C2+D2)-(A2+B2)<1, TRUE,FALSE)

[tracy702]

You are genius! THANK YOU, THANK YOU, THANK YOU!!!!!