I have two column totals that are formatted in Time:
=SUMIF(D2:D30,"Him",C2:C30) and =SUMIF(D2:D30,"Me",C2:C30) I want to subtract
"Him" Totals from "Me" totals and show the results as either a positve time
in Black or a Negitive Time in Red? The Formula I have now for that cell is
as follows: =TEXT(ABS(E31-F31),"h:mm")