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.

```=IF(C1<72:00:00,1,0)
```

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?

Nov 12, 2022 in Others 450 views

## 1 answer to this question.

Actually, Excel is quite accommodating in this regard. The important thing to remember is that date, time, and differences are expressed in decimals, with the full piece representing the number of days and the decimal representing the fractional days (hours, minutes).

So - for your example - after doing the subtraction, you should flag that particular field with =C1 < 3 ==> TRUE (if less than 72 hours), FALSE (otherwise)
• 63,160 points

## Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

## Is there a way to produce a sum according to date/time stamp values of another column on excel?

Assuming the input data for the second ...READ MORE

+1 vote

## Between cyber security and CCNA profession which one is best in terms of time to become an expert and salary payment

CCNA professional is more inclined towards the ...READ MORE

## Average TIME Calculation differs between Excel and PowerBI

They are calculating different things. In Power ...READ MORE

## MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

## In excel how do I reference the current row but a specific column?

Put a \$ symbol in front of ...READ MORE

## Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

## How to create DropDown which have dynamic Validation List

In my data table, the columns "Category" ...READ MORE