All,

In the attachment, column D came over from HTML and appears in two formats, mm:ss and mm:ss:00. However, when I try to do a vlookup to match MP to a player name, it returns a number with a decimal, like 1.5. Is it possible to convert the MP data to a decimal for minutes and parts of minutes?

For example, row 2 shows 35:29:00 what I'd like it to show is 35.48333. Is that possible?

MP Sample.xlsx

Thanks