Add or Subtract Time

[Steved]

Hello from Steved

1209:48 1211:01 = 1:13 is this formula B1-A1
1211:01 1209:48 = -1:13

Okay If you look at the above how do I put a formula in C1
that will reflect, A1 may be Less than B1 in this case it
will return 1:13 however if A1 is greater than B1 it will
return -1:13 is it possible for a If Argument please. Or
Can you please sugguest what Formula.

Thankyou.

 

[Earl Kiosterud]

Steved,

There isn't a question in here. Do you want 1:13 (positive) in either case?
If so, use:

=ABS(B1 - A1)

 

[Steved]

Hello Earl from Steved

Thankyou very much.

Yes this is what I asked, but If the sum =1:13 fine
but if sums =1:13 negative is it possible using your
formula =ABS(B1 - A1)to show as -1:13, my reasoning is that
other staff look at this file.

Thankyou

 

[Earl Kiosterud]

Steved,

You can switch to the 1904 date system, which allows negative time values.
Forget the ABS. Tools - Options - Calculation. If there are any dates in
your cells, they'll have to be corrected. This will affect all the sheets
in the workbook.

 

[Steved]

Thanks Earl

-----Original Message-----
Steved,

You can switch to the 1904 date system, which allows negative time values.
Forget the ABS. Tools - Options - Calculation. If there are any dates in
your cells, they'll have to be corrected. This will affect all the sheets
in the workbook.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------




.