Looking for autosum help with numbers, letters and dates

[SlurpeeD]

I am trying to figure out the formula to do an auto sum with numbers letters and times in minutes and seconds.

Its basically a weekly tracker. Cells F4 through L4. I want M4 to add the times (ex 2+39), but ignore the X's which represent days off, and numbers which are their employee attributes (these number 1-46).

Thanks!

 

[Peter_SSs]

I would like each row to have a sum of hours represented as either 12:51 or 12+51,

See if this does what you want.

24 07 30.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Time	Imped	Time	Imped	Time	11	Time	Imped	Time	Imped	Time	Imped	Time	Imped
3	X	17	2+00	10	2+39	43	3+29	42	1+39	31	34	42	X	24	9+47
4	0	13	4+26	18	2+25	10	X	27	X	41	4+01	19	2+16	28	13+8
5	3+28	41	3+38	5	X	29	X	18	3+12	20	4+36	42	2+19	8	17+13
6	2+38	24	X	20	X	41	3+46	36	19	41	4+28	2	1	46	10+52
7	3+13	23	3+09	33	2+54	18	X	2	X	12	34	31	2+59	3	12+15
8	4+28	8	2+44	30	2+59	16	3+49	6	X	37	X	24		39	14+0
9	4+14	32	1+54	36	2+15	45	2+56	2	X	2	X	1	34	26	11+19
10	25	14	25	11	25	11	25	34	25	39	X	46	X	37	0+0
11	3+18	18	3+20	20	X	2	X	28	3+40	22	4+08	18	3+33	36	17+59
12	X	24	25	39	25	18	25	26	25	29	25	45	X	1	0+0
Sum time

Cell Formulas
Range	Formula
O3:O12	O3	=LET(v,--TEXTSPLIT(TEXTJOIN("+",,FILTER(A3:N3,ISNUMBER(FIND("+",A3:N3)),"0+0")),,"+"),q,SEQUENCE(ROWS(v)/2,,,2),ts,SUM(INDEX(v,q+1)),s,MOD(ts,60),SUM(INDEX(v,q))+(ts-s)/60&"+"&s)

 

[felixstraube]

Another option:

Book5.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2	Time	Imped	Time	Imped	Time	11	Time	Imped	Time	Imped	Time	Imped	Time	Imped	Total time
3	X	17	2+00	10	2+39	43	3+29	42	1+39	31	34	42	X	24	9:47
4	0	13	4+26	18	2+25	10	X	27	X	41	4+01	19	2+16	28	13:08
5	3+28	41	3+38	5	X	29	X	18	3+12	20	4+36	42	2+19	8	17:13
6	2+38	24	X	20	X	41	3+46	36	19	41	4+28	2	1	46	10:52
7	3+13	23	3+09	33	2+54	18	X	2	X	12	34	31	2+59	3	12:15
8	4+28	8	2+44	30	2+59	16	3+49	6	X	37	X	24		39	14:00
9	4+14	32	1+54	36	2+15	45	2+56	2	X	2	X	1	34	26	11:19
10	25	14	25	11	25	11	25	34	25	39	X	46	X	37	0:00
11	3+18	18	3+20	20	X	2	X	28	3+40	22	4+08	18	3+33	36	17:59
12	X	24	25	39	25	18	25	26	25	29	25	45	X	1	0:00
Sheet9

Cell Formulas
Range	Formula
O3:O12	O3	=LET(d, A3:N3, SUM(IF(ISTEXT(d), IFERROR(VALUE(SUBSTITUTE(d, "+", ":")), 0), 0)) )

 

[SlurpeeD]

Those both worked well! Thank you!

 

[felixstraube]

Thanks for the feedback. Glad we could help