Date/Time with True and False statements attached.

Hello,

I'm hoping you can help me with this. Let me give you my scenario:

I have a spreadsheet that has a contract status column, a contract date/time entered into the system column and a customer signed date/time column. The column for the Contract status has many different statuses in it but I'm only concerned with the status of Loaded. What I need to do is create a 4th column that tells me all the contracts with the status of Loaded that were signed within 24 hours of the date/time they entered into the system. I've tried a date formula with an IF statement in front of it and it gave me a date/time however, it was from the year 1900 so I don't think it calculated correctly.

Any help I can get with this is much appreciated!

Brian

Ok. I'm trying to post a sample spreadsheet of the data but I'm having issues with the attachment option. It's blank and drag & drop doesn't seem as if it's
supported. I'll continue to work on getting you a sample so we can discuss what the desired outcome is and you can follow along.

I appreciate the quick response!

Ok, I didn't look down far enough in the advanced view. I believe I have it attached now. What I'm looking for is this:

If column A=Loaded, then calculate the date/time difference between columns B&C and output in column D YES if <=24 hours and NO if >24 hours

That's the desired outcome. Hopefully this makes sense.

Try: =IF(OR(A2<>"Loaded",C2=""),"",IF(C2-B2<=1,"Yes","No"))

Thank you both for the formulas. They both work for what I need. Now to add a pivot table to this column without breaking the formula

I appreciate the quick responses!

Brian