For my most recent three pregnancies, the chimes didn't sound. The very first sign of pregnancy was the Nauseous moodlet (from unknown causes). Apparently, unknown causes = pregnancy in Sims 3. I didn't time it so I can't confirm Jeanamarie's two hour claim, but the moodlet hit very soon after trying for baby.