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? |
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) |