It varied by child. The mad-hormonal-burst-into-tears-97-times-a-day stage was much more pronounced after the birth of my first child than my second. It got better after a few weeks and was a gradual process. After my second it wasn't such a big deal in the first place and didn't seem to last as long.
I think it is hard to tell sometimes where hormones leave off and utter exhaustion begins too....
That is so variable. With dc2 it took me months to lose that fuzzy headed feeling and settle into a routine. With dc1 it was a few weeks, there was just me, her and her dad and no pressure to do anything but care for her. The quicker I felt more like myself the sooner i felt like sex as well
I remember 3 weeks after DS1 I saw our cat walk down the garden path- this made me blubb as if someone had died ??? This was obviously my hormones.... I also wanted at 6 weeks after to leave the house and go and live in the woods for the summer. So I would say it lasts for a good 6 weeks !