XL can not display negative times/dates. You could "cheat" and do something
like:
=IF(B1A1,"-","")&TEXT(B1-A1,"h:mm")&" hrs"

--
Best Regards,

Luke M
"Radhakant Panigrahi" wrote in message
...
Hi,

i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want
to
calculate the difference between B1-A1 which is -2.30 hrs, but in excel it
is
not coming only A1-B1 is coming which is +ve 2.30 hrs

can anybody help me.

regards,
radha