I have a tool that I made about 40 years ago, which is still going strong today.
Consists of a metre long piece of 1/4" round steel bar, (which was originally part of an electric fence post), with a female 1/4" UNF coupler pushed partly over the end of it and brazed in place. That has a 1/4" semi keyless chuck, with an outside diameter of about 30mm, screwed into it, which will accept any spade bit.
If fitted with a 32mm bit, the chuck will pass through the drilled hole, so can drill three joists at a time, and if fitted with a long shaft spade bit can deal with noggins halfway down a stud wall.