Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extracting times
I have a spreadsheet which has time ranges entered in the format "13:00 -
17:00" in a single cell. I wish to have these times automatically transferred to separate cells in another worksheet, eg "13:00" and "17:00" |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extracting times
Use Data-Text to Columns ... delimited by - to split into two columns....
Then either paste or link to the other worksheet. ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "Malters" wrote: I have a spreadsheet which has time ranges entered in the format "13:00 - 17:00" in a single cell. I wish to have these times automatically transferred to separate cells in another worksheet, eg "13:00" and "17:00" |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extracting times
Try this...
If the format is *always* 00:00 - 00:00... A1 = 13:00 - 17:00 =--LEFT(A1,5) =--RIGHT(A1,5) If the format varies like 0:00 - 00:00... =--LEFT(A1,FIND(" ",A1)-1) =--MID(A1,FIND("-",A1)+2,6) Format as h:mm -- Biff Microsoft Excel MVP "Malters" wrote in message ... I have a spreadsheet which has time ranges entered in the format "13:00 - 17:00" in a single cell. I wish to have these times automatically transferred to separate cells in another worksheet, eg "13:00" and "17:00" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
Extracting Info from within a cell multiple times | Excel Worksheet Functions | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) |