Forum Discussion
Josh Moulton
Feb 09, 2018Copper Contributor
Help with Excel formulas
I have 2 Columns that are time. 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. How can I have it highlight the row?
Thanks.
I am running Excel 2016.
- Haytham AmairahSilver Contributor
Joshua,
You can use Conditional Formatting with a formula to do that.
But please let us know the kind of difference between the two? Is it greater than 15 hours or minutes?
I'll suppose that is greater than 15 hours, so the formula for the conditional formatting is like this:
=MOD($B2-$A2,1)*24>15
Please find the attachment file to see the solution!
- Josh MoultonCopper ContributorHello thanks for helping it is actually 15 minutes. How would that formula look.
- Haytham AmairahSilver ContributorIf so, the formula would be as follows:
=(MOD($B2-$A2,1)*24)>0.25