How long it lasts really depends on how long the mania lasts. It doesn't necessarily have to be there for the whole manic episode, though. I've had it last anywhere from a week to a couple of months. Sometimes it happens multiple times within the same manic episode with non-sexual periods in between. It varies quite a bit.