Extracting times

[Malters]

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"

 

[Sheeloo]

Use Data->Text to Columns ... delimited by - to split into two columns....

Then either paste or link to the other worksheet.

 

[T. Valko]

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