How long does it take for sodium valproate to work? Particularly, how long does it take for it to start affecting hypersexual side of BP unspecified?

Days. Valproate can have an some beneficial effect within a few days (and can even improve sleep the first night with an adequate dose), especially if an adequate blood level is achieved quickly. On the other hand, it could take weeks to see the maximal benefit.