| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing time and text format
I have data that is in a word document and it is written "37 Minutes". When
i copy that data into a cell in excel I want it to just show "37". I have tried different formatiing option but to no avail. I also have a field written out "1 Hour and 33 minutes" and want to convert that as well. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing time and text format
<"1 Hour and 33 minutes" and want to convert that as well.
convert to what? -- Kind regards, Niek Otten Microsoft MVP - Excel "Jamie" wrote in message ... |I have data that is in a word document and it is written "37 Minutes". When | i copy that data into a cell in excel I want it to just show "37". I have | tried different formatiing option but to no avail. I also have a field | written out "1 Hour and 33 minutes" and want to convert that as well. | | Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing time and text format
http://www.asap-utilities.com/?cf89A... Wm6I2bdXkgcx
check the asap utilities site, they have an addin that could solve your problems hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jamie" escreveu: I have data that is in a word document and it is written "37 Minutes". When i copy that data into a cell in excel I want it to just show "37". I have tried different formatiing option but to no avail. I also have a field written out "1 Hour and 33 minutes" and want to convert that as well. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing time and text format
=LEFT(A1,FIND(" ",A1)-1)/(24*60) for the first.
=LEFT(A4,FIND(" ",A4)-1)/24+MID(A4,FIND("and",A4)+4,2)/(24*60) for the second. If you don't know which input cells will be in which format, you could try =IF(ISNUMBER(FIND("Hour",A1)),LEFT(A1,FIND(" ",A1)-1)/24+MID(A1,FIND("and",A1)+4,2)/(24*60),LEFT(A1,FIND(" ",A1)-1)/(24*60)) -- David Biddulph "Jamie" wrote in message ... I have data that is in a word document and it is written "37 Minutes". When i copy that data into a cell in excel I want it to just show "37". I have tried different formatiing option but to no avail. I also have a field written out "1 Hour and 33 minutes" and want to convert that as well. Any ideas? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing time and text format
4 minutes
18 minutes 2 minutes 3 minutes 6 minutes 1 minute 1 minute 2 minutes 1 hour 9 minutes 1 minute 22 minutes 1 minute 15 minutes 31 minutes 3 minutes 25 minutes 10 minutes 5 minutes 30 minutes Nope that did not work. The examples above is the data I am pulling from word. When I cpoy it into the cell and try to format it nothing happens. Any other ideas? "Marcelo" wrote: http://www.asap-utilities.com/?cf89A... Wm6I2bdXkgcx check the asap utilities site, they have an addin that could solve your problems hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jamie" escreveu: I have data that is in a word document and it is written "37 Minutes". When i copy that data into a cell in excel I want it to just show "37". I have tried different formatiing option but to no avail. I also have a field written out "1 Hour and 33 minutes" and want to convert that as well. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing the format for the time shen entered as HHMM to HH:MM | Excel Discussion (Misc queries) | |||
| Changing a cells format (Time) | Excel Discussion (Misc queries) | |||
| How do I stop excel from changing my ratios into time format? | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Changing Text to Time in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
