In article , "=?
Utf-8?B?dmVsZSBQaGFudA==?=" <vele
says...
how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
and 43 seconds)

=MINUTE(C31)+SECOND(C31)/100 where C31 contains the time in hh:mm:ss.

Note that XL may format the cell containing the formula with a time
format. If so, change it to 'General'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions