Colonoscopy?

How long were you told the procedure would be? How long did the procedure actually take? How much time total were you in the office or hospital?