Change date format (years, days, hours) to days

[Fjura]

Hello,

May I ask if someone knows how I could change this kind of format (years, days, hours) for example: "220 y 344 d 12 h" to a number of days?



So "220 y 344 d 12 h" would be "80644,50"

thanks!

 

[Fjura]

I have slightly different solution if want to try:

If all your data is in Column A
I will highlight column A, select "Text to Columns" from the data Tab
Select "Delimited" and select next
Tick only the "space" delimiter and click next once again
Choose the columns that's have "y", "d" and "h" and select the format "Do not import column (skip)
Set Destination as =$B$1
Click Finish.
You now have years, days and hours in separate columns.
A simple formula in E1 will give you the result you want: =(B1*365)+C1+(D1/24)

thanks man, this is pretty cool solution!