Excel Formula for adding training times.
 

Does anyone know of a formula to add cells with training times in a
hour+minute format? Example: Cell C1 is 1+12 (1 hour and 12 minutes traning)
and cell C2 is 0+55 (55 minutes of training) equals cell C3 3+07 (3 hours and
7 minutes total training (i.e.: 1+12 and 0+55 = 3+07).

Excel Formula for adding training times.
 

Replace the + signs with colons.
[And you'll find that 1:12 + 0:55 comes to 2:07, not 3:07.]

If, for some strange reason, you want to leave the + signs in there, you
could do the calculation with =SUBSTITUTE(C1,"+",":")+SUBSTITUTE(C2,"+",":")
and format the result as time.
--
David Biddulph


kilomike1 wrote:
Does anyone know of a formula to add cells with training times in a
hour+minute format? Example: Cell C1 is 1+12 (1 hour and 12 minutes
traning) and cell C2 is 0+55 (55 minutes of training) equals cell C3
3+07 (3 hours and 7 minutes total training (i.e.: 1+12 and 0+55 =
3+07).

Excel Formula for adding training times.
 

If you have to use the + instead of the :
then:
=LEFT(C1,FIND("+",C1)-1)/24+MID(C1,FIND("+",C1)+1,255)/(24*60)+LEFT(C2,FIND("+",C2)-1)/24+MID(C2,FIND("+",C2)+1,255)/(24*60)

and format C3 as [hh]:mm
--
Gary''s Student - gsnu200909


"kilomike1" wrote:

Does anyone know of a formula to add cells with training times in a
hour+minute format? Example: Cell C1 is 1+12 (1 hour and 12 minutes traning)
and cell C2 is 0+55 (55 minutes of training) equals cell C3 3+07 (3 hours and
7 minutes total training (i.e.: 1+12 and 0+55 = 3+07).