excel time formulas

A

aly1cat

I have a column which shows a format of hours, mins and seconds an
would like to find a formula which can convert it into minutes only
i.e 10:50.2
 
B

Bob Phillips

Format the cells as [mm]

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top