Hi,

Not sure what the Dash " - " at the beginning of the data means (does it mean negative?, or it doesn't mean anything?)
Assuming the Dash means nothing, here's one way:

Excel 2016 (Windows) 64 bit
A
B
1
 -2d 10h 2 day(s) 10 hour(s)
2
 -27min 27 minute(s)
3
 -2h 29m 2 hour(s) 29 minute(s)
4
 -1w 1d 1 week(s) 1 day(s)
5
 -1w 1d 1 week(s) 1 day(s)
6
 -2d 12h 2 day(s) 12 hour(s)
7
 -2d 8h 2 day(s) 8 hour(s)
8
 -1d 18h 1 day(s) 18 hour(s)
9
 0min 0 minute(s)
10
 0min 0 minute(s)
11
 1min 1 minute(s)
12
 -1w 2d 1 week(s) 2 day(s)
13
 -3h 59m 3 hour(s) 59 minute(s)
Sheet: Sheet104

Excel 2016 (Windows) 64 bit
B
1
 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"w"," week(s)"),"d"," day(s)"),"h"," hour(s)"),"min","m"),"m"," minute(s)")
Sheet: Sheet104

Formula copied down.