Convert week day hours to show total value

[Anonymous]

i have data in below format :

Project	Duration
Project 1	4d
Project 2	5w 1h
Project 3	4m
Project 4	1w 5h

I want values to be shown like total of duration , eg: 6w 4d 6h 4m 

Requirement is to show how much of time is taken to complete project out of total time

Thanks for any help in advance.

[amitchandak]

@Anonymous , Are you getting duration like text or like a number ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.