Negative Time

[jr]

busy but it works:
if times are in A1 and A2,

=IF(A2=A1,"",IF(A2>A1,TEXT(TIME(INT((A2-A1)*24),((A2-A1)
*24-INT((A2-A1)*24))*60,),"hh:mm"),"-"&TEXT(TIME(INT((A1-
A2)*24),((A1-A2)*24-INT((A1-A2)*24))*60,),"hh:mm")))

let me know if it works.

 

[Rick C]

A little shorter:

=IF(A2>A1,TEXT(ABS(A1-A2),"-h:mm"),A1-A2)