This might help

DECLARE @StartTime VARCHAR(MAX),@X XML

SELECT @StartTime = '7:00 AM

12:30 PM'

SELECT @X = CONVERT(XML,'' + replace(@StartTime,'','</br>') + '</br>')

SELECT x.i.value('.','varchar(max)') AS [StartTime]

FROM @X.nodes('//br') x(i)