Convert Data Into Hours In Excel?

I want to convert the data below into hours in excel. At the moment I am doing it manually.

how I can do this in a more efficient way, reduce time and increase accuracy.

For example

1h 18m 28s would be 1.25 hours.
1d 4h 55m 16s would be 28.90 hours.

Example of Data

47m 26s
48m 46s
59m 36s
1h 2m 51s

[Code].....

I receive the data in a automated report. At the moment I have add four columns as below

1) Day- i use the mid function to work days

2) Day to Hours- multiply column 1 by 24

3)Hours- Manually type in hours eg, 4h 55m= 4.80 hours 19h 33m= 19.50 hours

4) Total Hours- Add together column 2 and 3. (Ignore seconds)