Counting Only if Conditions are Met

[campeao006]

Hi all. I am having some difficulty setting up a proper command to count the difference in time, but only if I have categorized a cell a certain way. For example, below, I would like for the "Time Difference" column to be calculated for just D2 and not D3, as row 3 is classified as a "1". I know the minute difference calculation is =ROUND(ABS((C2-A2)*1440),2), but I don't know how to make this conditional. Ideally, I would like a function that when input into D2, would output as 7 and in D3 would output as nothing (not 0, but nothing).

 

[etaf]

before you formula
=ROUND(ABS((C2-A2)*1440),2),

You can add an IF
=IF( C2 <> 1, ROUND(ABS((C2-A2)*1440),2), "")

Why C2-A2 - Should that be B2-A2

 

[campeao006]

before you formula
=ROUND(ABS((C2-A2)*1440),2),

You can add an IF
=IF( C2 <> 1, ROUND(ABS((C2-A2)*1440),2), "")

Why C2-A2 - Should that be B2-A2

Thank you so much, this worked perfectly.

You're right, it should be B2-A2 - I just copied that from my Excel sheet where I have an additional column that I didn't paste in here.

 

[etaf]

you are welcome