I think you could truncate the milliseconds like this:
SET TimeFormat='h:mm:ss TT';
floor(StartDate)+Time#(Time(StartDate)) as StartDate2
[ StartDate, Amount
StartDate2 should only hold time up to the seconds now. And in your example, the sum seems to be correct and will return 500.
Hope this helps,