| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi, Harlan Grove, ? about negative time formula
I found a post with your reply of,
=IF(TargetTime<=ActualTime,"+ ","- ")&TEXT(MAX(TargetTime,ActualTime)-MIN(TargetTime,ActualTime),"[m]:ss") I made it work for me like this, =IF(C3<=D3,"+ ","- ")&TEXT(MAX(D3,C3)-MIN(D3,C3),"[m]") The display in the cells is -0. Is there a way to format so the cell looks blank until a calculation is made? Also can the cell display OT if the result = 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) | Excel Worksheet Functions | |||
| formula for negative time durations | Excel Worksheet Functions | |||
| Harlan Grove PULL Code Help Please | Excel Worksheet Functions | |||
| PULL function (Harlan Grove) - can it use Named Ranges? | Excel Worksheet Functions | |||
| # of Functions per cell >> for Harlan Grove | Excel Worksheet Functions | |||
![Dale G[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
