Minute Format Problems

[Sweepin]

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

[jeffreybrown]

In column F you could use...

D2*24

[shg]

In F2 and copy down, =D2*24 and format as 0.000

	A	B	C	D	E	F
1	Date	Name	PlayerID	MP	VLOOKUPID
2	10/28/2008	LeBron James	350	36:00:00	39749350	36.000
3	10/28/2008	Delonte West	718	35:29:00	39749718	35.483
4	10/28/2008	Mo Williams	736	31:18:00	39749736	31.300
5	10/28/2008	Zydrunas Ilgauskas	335	30:24:00	39749335	30.400
6	10/28/2008	Ben Wallace	704	19:03	39749704	19.050

[Sweepin]

That did it. Thanks!