Sort Values

Originally Posted by sandy666

or
B2: =IF(LEN(LEFT(A2,SEARCH(" ",A2)-1))<2,"0"&LEFT(A2,SEARCH(" ",A2)-1),LEFT(A2,SEARCH(" ",A2)-1))
and drag down
then select both and sort by B column

@sandy:
You paid no attention to Hrs and Mins!