Time Calculations-- Help

[comasoud]

Hi Everybody.

I am actually having a problem when i am doing some calculations wit
cells containing time values.

Actually i have 2 cells A and B containing time values.

A has the value 8:45 and B has the value 8:50

Now when i do B-A i get the correct answer 0:05 but...
when i do A-B that is when value of A is less than value of B, i ge
#########. and i want to get the -0:05
I want to know if there is a posibility for me to get the desired valu
i.e -0:05.

Thanks in advanc

 

[Nick Hodge]

Excel cannot work with negative times unless you use the 1904 date system
(Tools>Options...Calculation)

There are workarounds which you may be able to use...see here:

http://www.cpearson.com/excel/datearith.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)