In order to establish a flag against each record when the time difference is smaller than 72 hours, I'm comparing booked DateTime values between two appointments.
It is straightforward to determine the difference in hours using the formula: Setting the cell format to [h]:mm after entering =B1-=A1
To determine whether the calculated amount is less than or larger than 72 hours, I then attempted to utilize an IF statement in a separate column.
This, and variations of it using double quotes, etc hasn't worked for me. I guess the problem is that the calculated value in column C is still in DateTime format. Can anyone please advise the correct syntax to make the IF statement work?