How long did the watergate investigation take

It depends on what you take to be the beginning and what the end. It lasted two years if you understand it as from the time it was revealed to the time Nixon resigned. It lasted 5 years if you take it from the time Nixon began doing it to the time he resigned.