Good morning!

I have an application that outputs a CSV file with time stamps in text format that looks like this: 5 Days 7 Hrs 30 Mins

I'm needing to do a calculation with the time stamp but need to convert it to an actual time value first. in the format of d:hh:mm

Is there a formula I can use to accomplish this task? I have hundreds to convert!.

Update:

(A1)`10 Days 10 Hrs 25 Mins 15 Secs`

(B1)`=IFERROR(VALUE(MID(A1,1,SEARCH("Days",A1)-2)),0)`

(C1)`=IFERROR(VALUE(MID(A1,MAX(SEARCH("Hrs",A1)-3,1),2)),0)`

(D1)`=IFERROR(VALUE(MID(A1,MAX(SEARCH("Mins",A1)-3,1),2)),0)`

(E1)`=IFERROR(VALUE(MID(A1,MAX(SEARCH("Secs",A1)-3,1),2)),0)`

(F1)`=TEXTJOIN(":",TRUE,B1:E1)`

The result in (F1) 10:10:25:15

Is there a way that I can shorten this into a single formula with a formatting the cell as dd hh:mm:ss