Add or Subtract Time

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
Steved,

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

=ABS(B1 - A1)
 
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
 
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.
 
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
-------------------------------------------




.
Click to expand...
 
Back
Top