I Have a work sheet with two times in cells A1 and A2 in number format mm:ss.
Cell A3 callculates A2-A1.
If the value is positive is displays with no problem. However negative
values give ######## in the cell.
I have used the following to resolve.
=IF(A2-A1<0,"-"&MINUTE((A2-A1)*(-1))&":"&SECOND((A2-A1)*(-1)),A2-A1)
Is there a more elagant way to resolve.
Regards and Thanks in advance
Francis,
Bookmarks