Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text in mm:ss to time
_I have times in text format as mm:ss (eg. 03:45) and want to convert them to
time numbers in the same format. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text in mm:ss to time
Do you mean you want to convert them in place? Select the cells containing
these "text times", click Data/Text To Columns on Excels menu bar and click Finish on the dialog box that appears. You might have to then format the cells to display the way you want. Rick "P Boric" wrote in message ... _I have times in text format as mm:ss (eg. 03:45) and want to convert them to time numbers in the same format. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text in mm:ss to time
=TRIM(A1)*1
Format as mm:ss "P Boric" wrote: _I have times in text format as mm:ss (eg. 03:45) and want to convert them to time numbers in the same format. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text in mm:ss to time
insert 0 in some cell, copy, select yr data, Edit-PasteSpecial-
Values (select Add) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text in mm:ss to time
Thanks, it works but with some "details" (I have tried before with similar
function CLEAN and got similar results): If I use the mm:ss format I get the answer in the wrong order, (for instance 03: 25 I get 25:03 instead) If I choose format hh:mm I get the right order but I don't know why Furthermore in this last format, when a number is greater than 30 minutes (for instance 46:25), I get displayed a different number as 22:25, but internally is stored the right value, as when I add it othe time as 02:15 I get the right answer 48:40 Very strange isnĀ“t? I have checked the regional settings and seem are ok "Hershey" wrote: =TRIM(A1)*1 Format as mm:ss "P Boric" wrote: _I have times in text format as mm:ss (eg. 03:45) and want to convert them to time numbers in the same format. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text in mm:ss to time
03:45 will not default to minutes and seconds, but to hours and minutes.
Hershey may therefore have intended not to say =TRIM(A1)*1 but =TRIM(A1)/60 You may also want to format as [mm]:ss, rather than as mm:ss, in case your number of minutes goes beyond 60. -- David Biddulph "P Boric" wrote in message ... Thanks, it works but with some "details" (I have tried before with similar function CLEAN and got similar results): If I use the mm:ss format I get the answer in the wrong order, (for instance 03: 25 I get 25:03 instead) If I choose format hh:mm I get the right order but I don't know why Furthermore in this last format, when a number is greater than 30 minutes (for instance 46:25), I get displayed a different number as 22:25, but internally is stored the right value, as when I add it othe time as 02:15 I get the right answer 48:40 Very strange isn“t? I have checked the regional settings and seem are ok "Hershey" wrote: =TRIM(A1)*1 Format as mm:ss "P Boric" wrote: _I have times in text format as mm:ss (eg. 03:45) and want to convert them to time numbers in the same format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Text Time to Excel Time | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Time to text | Excel Worksheet Functions | |||
Time from Text | Excel Discussion (Misc queries) | |||
Convert Text Time to Time | Excel Discussion (Misc queries) |