I had a CT scan last week, in the UK. Took around 20 minutes. The exact process depends if they are looking at your small or large intestine. Mine was the colon, the only uncomfortable thing about the test was being "inflated" from my rear end! If you've had surgery in the past, apparently a little pain is common, but it wasnt bad.
I had to stick to a low residue diet for a few days before hand, but was back to normal as soon as I left the hospital.
I think a small bowel CT is a little different, maybe easier as there is no "inflating" required....
Anyway, good luck, it'll be fine.