Thank you , however i have following example, can you please explain how to
convert it into Minutes:

1:02
5:55
0:13
0:21
51:37:00
1:15
0:00
4:29
0:59
15:42
0:05
1:33
0:05
0:04
4:48

Vele Phant

"Tushar Mehta" wrote:

> In article <5F13B001-9B6B-4D5D-BD81-ACAAF5799CF6@microsoft.com>, "=?
> Utf-8?B?dmVsZSBQaGFudA==?=" <vele Phant@discussions.microsoft.com>
> 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
>