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"

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"

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"