Personally, I've had one that lasted an entire day, but it was a lucid dream that took place in four different dreams. I MILDed between each dream segment.

I also had one that spanned two weeks, but that one was semi-low level lucid.

Usually, I have a one to one correspondance with real time. That is, an hour in real time = an hour in dream time