It really depends on the judge, though. Sometimes it is just a couple of days and other times it is a few weeks. If you are in a hurry, you can schedule a hearing through Decree on Demand which essentially sets an appointment with a commissioner to sign the decree at a certain date and time.
It usually will take at least a couple of weeks for the Judge to sign the consent decree and return it to you both. Once the consent decree is signed and entered by the Court, you are divorced. You can also call the Judicial Assistant of the Judge in your case to get a timeframe of when that might be done, or to follow up.