in my experience, they kept the passport overnight in order to insert the new pages (why, I have no idea). My appointment was in the afternoon; I don't know if they would have been able to do same-day if I had visited in the morning.