We are in the pocess of compiling reports and the format of the time duration is not formated in total hours. There are entries that are formated:

1mon 2w 4d ...

1y 2mon ... 

2w 2d ...

5d 4h ...

We need the report to pull these values in total number of hours

[h]:mm:ss format 

Excel will not format these unless you have a super fancy formula