That should already be sargable, if not:
SET @EndDate=DATEADD(d, 1, @EndDate)
WHERE TimeAdded between @StartDate and @EndDateWhat do you mean by "sargable" anyway? If you're selecting all or most of the columns, and the date range is not very selective a table scan may likely be the most efficient. Make sure your statistics are up to date.