difference between two time
Hi Luke,
The formula helped me however if i have the B1<A1 then i am facing issue...
I need the below format the column A is fixed with 12 PM
12:00 PM 9:30 AM -2:30 hrs
12:00 PM 9:30 PM 9:30 hrs
Regards,
Radha
"Luke M" wrote:
XL can not display negative times/dates. You could "cheat" and do something
like:
=IF(B1<A1,"-","")&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
.
|