View Single Post
  #4  
Old June 3rd, 2010, 01:41 PM posted to microsoft.public.excel.worksheet.functions
Radhakant Panigrahi
external usenet poster
 
Posts: 43
Default difference between two time

Hi Luke,

The formula helped me however if i have the B1A1 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(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



.