EASY time adding question

[Hoffman]

Hi all,
Thanks for any help on this easy one.

I need to add time.
The time is only minutes and seconds and needs to show the titles too

for example
A1
02 min 45 sec

A2
04 min 26 sec

A3
I need to add those and have the labels show, so it would produce

07 min 11 sec


I do not need hours just min and sec.


Below is something the great people here once helped me with BUT this includes hours (which I don't need) and was subtracting the two (now I need to add).
Maybe you can edit this to be just min and sec and ADD them.

=HOUR(TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(J67," hrs ",":")," min ",":")," sec",""))-TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I67," hrs ",":")," min ",":")," sec","")))&" hrs " & MINUTE(TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(J67," hrs ",":")," min ",":")," sec",""))-TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I67," hrs ",":")," min ",":")," sec","")))&" min " & SECOND(TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(J67," hrs ",":")," min ",":")," sec",""))-TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(I67," hrs ",":")," min ",":")," sec","")))&" sec"

Thanks so much!

Barry

 

[awoohaw]

try:

mr excel questions 34.xlsm
	A	B	C
1	02 min 45 sec
2	04 min 26 sec
3	07 min 11 sec
4	custom format: mm "min" ss "sec"
Hoffman

Cell Formulas
Range	Formula
A1	A1	=TIME(0,2,45)
A2	A2	=TIME(0,4,26)
A3	A3	=A1+A2

 

[Hoffman]

try:

mr excel questions 34.xlsm
	A	B	C
1	02 min 45 sec
2	04 min 26 sec
3	07 min 11 sec
4	custom format: mm "min" ss "sec"
Hoffman

Cell Formulas
Range	Formula
A1	A1	=TIME(0,2,45)
A2	A2	=TIME(0,4,26)
A3	A3	=A1+A2

worked perfectly!!

Thanks much

Barry

 

[awoohaw]

Your welcome, Im pleased you found an answer here!

Best Wishes!

 

[Hoffman]

Your welcome, Im pleased you found an answer here!

Best Wishes!

Sorry to bother you again. After some consideration I may need the time to look a bit differently but same exact concept.

before it would say
A1
02 min 45 sec

A2
04 min 26 sec


Instead I need it to look like

A1
2:45

A2
4:26

A3
7:11

Could you help one more time? Same thing just instead of the words min and sec, it is written with a colon.

UPDATE: I think I got it by going into CUSTOM but it looks like this
02:45

is there a way for it to look like
2:45 (without the leading zero)

Thanks

Bary

 

[bebo021999]

Custome format:
Type:
h:mm

 

[awoohaw]

Sorry to bother you again. After some consideration I may need the time to look a bit differently but same exact concept.

before it would say
A1
02 min 45 sec

A2
04 min 26 sec


Instead I need it to look like

A1
2:45

A2
4:26

A3
7:11

Could you help one more time? Same thing just instead of the words min and sec, it is written with a colon.

UPDATE: I think I got it by going into CUSTOM but it looks like this
02:45

is there a way for it to look like
2:45 (without the leading zero)

Thanks

Bary

custom format as h:ss or h:s
If you want running minutes more than 60, wrap the minutes indicator in square brackets
[mm]:ss, [m]:ss, [m]:s.

 

[Hoffman]

custom format as h:ss or h:s
If you want running minutes more than 60, wrap the minutes indicator in square brackets
[mm]:ss, [m]:ss, [m]:s.

got it!!!

thanks!