Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
Convert my entire spreadsheet from inches to centimeters | Excel Discussion (Misc queries) | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |