Time value conversion

[admssm]

Hi,

in one collumn i have different time values (hr, min, sec ...), which id like to convert to the same- to have all in minutes. How can i do that..? Im sending picture what it looks like...

Thank you.

IB

[DonkeyOte]

Sample Excel files are generally better than images - also it helps if you detail some expected results - it's not clear if you want the results as Time values or as Decimal minutes ?

If you want result as genuine Time value

Please Login or Register  to view this content.

where original entry in B2, format result cells as [m]:ss

If you want Decimal Minutes - as above but multiply result by 1440

Please Login or Register  to view this content.

where original entry in B2, format result cells as Number to 2 Decimals

Above is assuming Slovak configuration re: delimiters

[snb]

Or use a macro for the whole range:

Please Login or Register  to view this content.