difference between two time
 

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

difference between two time
 

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

difference between two time
 

Hi

You can have negative times if you switch to the 1904 Date system, but
beware of any other dates you may have on the sheet altering.

Alternatively, if you can accept decimal times then
=(A1-B1)*24
Format the cell as General.
--

Regards
Roger Govier

"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

__________ Information from ESET Smart Security, version of virus
signature database 5166 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5166 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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


.