Convert Minutes to Seconds

Question

I have a spreadsheet with values as follows:

1:29.460

I need to convert it to

89.460

I have a huge amount of these play offsets. I can either do it in excel or perhaps using javascript.

Any advice on a formula appreciated!

Answer 1

Here’s a JavaScript solution:

function convert(input) {
    var parts = input.split(':'),
        minutes = +parts[0],
        seconds = +parts[1];
    return (minutes * 60 + seconds).toFixed(3);
}

convert('1:29.460'); // '89.460'