Check if two timestamps are 24 hours within each other

Hi there!

I am not really a developer, so apologies for asking a question I imagine might be easy for most!

I feel like I'd be able to get the result required from a Custom Column, but I just haven't been able to get the formula correct for it.

Scenario

I have an Appointment Date and Time Column

  • List item I have an appointment Date and Time Column
  • List item I have a Cancelled at Date and Time Column

I want to create a custom column that has a "Null" or "1" value in it where

1 = Cancelled at Timestamp is within 24 hours of Appointment Date
0 = Cancelled at Timestamp is over 24 hours of Appointment Date

I just can't seem to get this correct! Is anyone able to help me with this?

Thankyou in advance.

I would suggest you checkout: