Help with Excel formulas

Question

I have 2 Columns that are&nbsp;time.&nbsp; Example(one column(A) is arrival and the other column(B) is departures) I need them to highlight the row(A2,B2) when the difference between the two is greater than 15.&nbsp; How can I have it highlight the row?&nbsp;
Thanks.
I am running Excel 2016.

haytham amairah · Answer

Joshua,
&nbsp;
You can use https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f with a formula to do that.
But please let us know&nbsp;the kind of difference between the two? Is it greater than 15 hours or minutes?
I'll suppose that is&nbsp;greater than 15 hours, so the formula for the conditional formatting is like this:&nbsp;
=MOD($B2-$A2,1)*24&gt;15
&nbsp;
Please find the attachment file to see the solution!&nbsp;&nbsp;

josh moulton · Answer

Hello thanks for helping it is actually 15 minutes.  How would that formula look.

haytham amairah · Answer

If so, the formula would be as follows:

=(MOD($B2-$A2,1)*24)&gt;0.25

josh moulton · Answer

thanks again is there a way to have it work for each row of do I have to enter it separate for each row

haytham amairah · Answer

In the attached file, the conditional formatting formula is already applied to the whole column A and B, try to add a new record and see how it works.

Forum Discussion

Help with Excel formulas

7 Replies

Resources