Please help me get this IF statement right, my brain is fried.

I have several different columns to describe aspects of my Shift IDs which is Column A.

One of these columns is cancellation time of a shift, another is shift start time.

I need to know if cancellation time is within 24 hours before the start time or more than 24 hours before the start time.

Some of the cancellations take place after the start time if this impacts things.


1 Answer 1


You can find if the start time in cell S2 is more than 24 hours after the cancellation time in cell C2 by inserting this formula in a free cell in row 2:

=S2 - C2 > 1

See this answer for an explanation of how date and time values work in spreadsheets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.