Format and convert hours to Minutes

[samitnair]

Hello

I have a column A1 (Time) which has the following data and since it does not have similar formatting I am finding it difficult to convert it into minutes. Any help would be appreciated.

Time	Minutes
1d 3h 42m	1662
18h 38m	1118
34m	34
7h 5m	425

<tbody>
</tbody>

Regards
Samit Nair

 

[Yongle]

In column A .. is ONE DAY

1d or 1d 0h 0m

Does column A contain TEXT or time formatted values ?

 

[samitnair]

In column A .. is ONE DAY

1d or 1d 0h 0m

Does column A contain TEXT or time formatted values ?

yes the column contains day hour minute in text format

 

[joeu2004]

=ROUND(1440*(IFERROR(LEFT(A2,FIND("d",A2)-1),0)
 + IF(ISNUMBER(SEARCH("h",A2)),
   SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IFERROR(MID(A2,SEARCH("d",A2)+1,LEN(A2)),A2),"h",":"),"m","")," ",""),
   "0:" & SUBSTITUTE(IFERROR(MID(A2,SEARCH("d",A2)+1,LEN(A2)),A2),"m",""))), 0)

Also test with:
23d
12h

 

[samitnair]

Hello Joe,

That formula helped me and many thank you for your assistance

Regards