ExcelBanter - Subtracting Times

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Subtracting Times (https://www.excelbanter.com/excel-worksheet-functions/12587-subtracting-times.html)

Subtracting Times

I have to time fields. I need to find the difference between the two. It is
possible that either time could be greater so whichever cell has the earliest
time gets subtracted from the other. However, if the first time is greater
than the second I want the font to be red for the calculated difference. Here
is my current formula, how do I include changing the fontcolor if the second
IF (C4-B4) is false.

IF(C4 = "","",IF(B4C4,B4-C4,C4-B4))

Nevermind, I figured it out using the Conditional Formatting from the Format
menu.

"NChris" wrote:

I have to time fields. I need to find the difference between the two. It is
possible that either time could be greater so whichever cell has the earliest
time gets subtracted from the other. However, if the first time is greater
than the second I want the font to be red for the calculated difference. Here
is my current formula, how do I include changing the fontcolor if the second
IF (C4-B4) is false.

IF(C4 = "","",IF(B4C4,B4-C4,C4-B4))