|
|
#2
03-28-2017, 09:18 AM
|
|||
|
|||
If I understand correctly, try this:
=IF(MAX([@Total2],[@Début])-MIN([@Total2],[@Début])=0,"",TEXT(MAX([@Total2],[@Début])-MIN([@Total2],[@Début]),"-H::MM")) Out of curiosity, why are you using the TEXT function? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 6 (or 7) Nested IFs!
|
JuicyHMouse | Excel | 1 | 03-11-2017 06:41 AM |
| nested formula using IF & AND | paxon | Excel | 3 | 02-18-2016 05:32 AM |
|
Nested IF
|
TDWolsey | Excel | 2 | 01-06-2016 11:31 PM |
|
Adding rows and copying formulas
|
ejtoll | Word Tables | 1 | 12-05-2012 05:09 PM |
|
Nested IFs
|
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode