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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]Minutes[/TD]
[/TR]
[TR]
[TD]1d 3h 42m[/TD]
[TD]1662[/TD]
[/TR]
[TR]
[TD]18h 38m [/TD]
[TD]1118[/TD]
[/TR]
[TR]
[TD]34m [/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]7h 5m [/TD]
[TD]425[/TD]
[/TR]
</tbody>[/TABLE]

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