Hello all,

My first post!

I do have a question, hopefully someone is able to help me.

I have data in time format, so hours:minutes:seconds, for example 1:30:00 (one hour, thirty minutes, zero seconds)

What I would like to achieve is I would like to convert this to minutes.

I am looking for formula which would take the first number (1) and multiply it by *60.

Then skip ":" and take second number, (30) and add it.

So with formula, when I have original 1:30:00 that would return 90.

Thanks in advance.