In C1 enter:
=IF(B1<A1,"-","") & TEXT(ABS(B1-A1),"hh:mm")

--
Gary''s Student - gsnu200902


"deepak" wrote:

Hello !

Thanks to all you for helping out me in my previous problem. This i have a
problem with diplaying negative times,

Say A1= 10:30 (format is hh:mm) and B1 = 8:30 (format is hh:mm).
when C1=B1-A1, the value is displayed as ##### with notification negative
dates and times are displayed as ######.
Is there a way to display the negative time (for e.g. 8:30 - 10:30 = -2:00)

Thanks