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 104 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)
• 51,600 points

+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

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## Calculate time difference in hours between two dates and times

Simply subtract the two dates to get ...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