| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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)) |
|
#2
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
| Subtracting times | Excel Discussion (Misc queries) | |||
| Subtracting Times | Excel Worksheet Functions | |||
| subtracting times using 24 hour clock | Excel Worksheet Functions | |||
Linear Mode
