Time

[Lemmo86]

Hi,

I have a spread sheet where I need to convert the time. I download a report and the time comes out as an example 1h 30m. The report can’t be change but can excel change this into just minutes so I can work with the data?

 

[SunnyAlv]

Can you insert an example picture or table to make it easier for someone to understand the desired achievement?

 

[Lemmo86]

So column J is what comes out of the report. I just want to change it into minutes like column K.

 

[Dave Patton]

Time 2023.xlsm
	J	K
2	1h 30m	90
3	21h 0m	1260
4
2i

Cell Formulas
Range	Formula
K2:K3	K2	=TEXTBEFORE(J2,"h ")*60+TEXTAFTER(TEXTBEFORE(J2,"m"),"h ")

 

[Lemmo86]

Thank you so much, worked a treat.

 

[Dave Patton]

Thanks for the feedback.