Excel 2007 : Extracting alphanumeric strings

Hello

First post around here

I have to write monthly reports and the software from the data come does not export. I had to copy and paste all the values.

To make some statistics I have to convert time values furst. Values after paste comes as 7h38m2s, 7 hours, 38 minutes, and 2 second.

There is problem to extract the number using Extract function because values does not always comes in same order. Some examples I have to deal with

1d8h0m
7d7h22m
20d17h22m
15h57m16s
2h37m20s
14h7m5s

So on.There no standard dd,hh,mm,ss
As you can see, there are many values and I have to deal with all. Zero is always ignored and this is the problem to extract function. Because I have to predefine the range of the row to extract but positions changes, and row range sometimes does not work.

I folloed this http://office.microsoft.com/en-us/ex...001154901.aspx

How to I extract that values into three cells at least. Hour cell, Minute cell and Second cell.

Do you know some macro that can help me in conversion?

Thanks in advance.