Can you wear a condom for many hours at a time or overnight?

No, because as soon as your erection goes it will fall off.