Thread: Adding IF in nested formulas
View Single Post
 
Old 03-28-2017, 09:18 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
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?
Reply With Quote