Subtracting Times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(B4>C4,B4-C4,C4-B4))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leave final cell blank 2
Sumproduct in matrix means 3
Using cell contents in Vlookup formula 3
fromula error 6
Timesheet formula problem 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
weight loss 3
Percentage Formula in Excel 3

Back
Top