Extracting times

  • Thread starter Thread starter Malters
  • Start date Start date
M

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"
 
Use Data->Text to Columns ... delimited by - to split into two columns....

Then either paste or link to the other worksheet.
 
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
 
Back
Top