Convert time spent to time

[Anonymous]

I have a column time-spent:

1H3M

4H7M

2M

I need to convert de time to be comptable in excel. 

For example 1H30M will be in total hours 1.5h

[amitchandak · Accepted solution]

@Anonymous , Try a new column

new column =
var _1 = SUBSTITUTE([column], "H", ".")
var _2 = SUBSTITUTE(_2, "M", "")
return
Quotient(_2*1,1) + (mod(_2,1)*10/6)

[AilleryO]

Hi,

Can you tell us exactly how is stored the time you want to convert.

Is it like you wrote 1h3m with the letters ? or more classic 01:03 ?

A screen copy of your data (not sensitive ones) might help us to help you 😉