Sunday afternoon is definitely the best time to have your auction end. Whenever I list items I always time my auctions so they'll end at 5.00pm on a Sunday. As others have said, this is the time of the week when there are more likely to be a lot more potential bidders/buyers on eBay.