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

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

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

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 , "=?
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

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 ,
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 , "=?
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

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" wrote in message
...
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 , "=?
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

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©" wrote in message
...
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" wrote in message
...
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 , "=?
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