how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43

[vele Phant]

how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 (68 minutes
and 43 seconds)

[Tushar Mehta]

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

[vele Phant]

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
>

[Tushar Mehta]

I don't know that those numbers mean. Is it information in hh:mm or
mm:ss? In any case, you already have the building blocks with my last
post. The functions MINUTE() and SECOND() and you can guess by
extension that there is a function HOUR(). Just put the pieces
together depending on what numbers you have.

--
Regards,

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

In article <97609425-ABCD-409C-92BB-96BA8693845F@microsoft.com>,
velePhant@discussions.microsoft.com says...
> 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
> >
>

[JethroUK©]

why might you want to replace a colon ':' with a '.' dot?

i think there's more of this you haven't yet mentioned


"vele Phant" <velePhant@discussions.microsoft.com> wrote in message
news:97609425-ABCD-409C-92BB-96BA8693845F@microsoft.com...
> 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
> >

[JethroUK©]

it looks to me like you have hours & minutes, and you want these converted
to minutes/seconds - if so just divide them by 60


"JethroUK©" <reply@the.board> wrote in message
news:sMoOe.21$yw1.12@newsfe1-gui.ntli.net...
> why might you want to replace a colon ':' with a '.' dot?
>
> i think there's more of this you haven't yet mentioned
>
>
> "vele Phant" <velePhant@discussions.microsoft.com> wrote in message
> news:97609425-ABCD-409C-92BB-96BA8693845F@microsoft.com...
> > 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
> > >
>
>