How long does it take to get a hormone for menapause out of your system?

my husband of 32 years might be going thru some male crisis hes unhappy with his life and feels that he hasn't fullfilled his dreams hes changed his appearance, hes lost a lot of weight hes lost interest in his family and in me hes extremely moody and jumpy and he left me for another woman hes 51 how long will this last