Sort Values

Another way

Formula:

=SUMPRODUCT(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1," mins","")," hrs ","^")," days ","^"),"^",REPT(" ",256)),(ROW($1:$3)-1)*256+1,256)),{1440;60;1})

One other way ... array entered ...

Formula:

=SUM(MID(A1,SMALL(IF(MID(" "&A1,ROW(INDIRECT("1:"&LEN(" "&A1))),1)=" ",ROW(INDIRECT("1:"&LEN(" "&A1)))),{1,3,5}),2)*{1440,60,1})

	A	B	C	D
1	1 days 15 hrs 49 mins	2389		2389
2	1 days 16 hrs 0 mins	2400		2400
3	1 days 19 hrs 30 mins	2610		2610
4	2 days 15 hrs 15 mins	3795		3795
5	2 days 20 hrs 43 mins	4123		4123
6	4 days 21 hrs 24 mins	7044		7044
7	6 days 7 hrs 21 mins	9081		9081
8	11 days 4 hrs 26 mins	16106		16106
9	18 days 0 hrs 19 mins	25939		25939
10	19 days 3 hrs 5 mins	27545		27545
11	28 days 7 hrs 28 mins	40768		40768
12	29 days 2 hrs 28 mins	41908		41908
13	31 days 8 hrs 34 mins	45154		45154
14	53 days 12 hrs 15 mins	77055		77055