Use the following TSQL:
Select * from [YourTable]
Order By
DatePart(hh, SomeDate), DatePart(mi, SomeDate), DatePart(ss, SomeDate)
-- SomeDate is the field you want to sort on
-- YourTable is your table