Forum Discussion
Text combined with formula result
I'm comparing time intervals and cannot display a negative result. To get around that, I have
IF(H3>M3,H3-M3,M3-H3)
To indicate a negative value, I want to show a "-" before the result of...
Like so:
=IF(H3>M3,H3-M3,TEXT(M3-H3,"-hh:mm")
Note that for negative times your cell now actually contains a text value.