As others have mentioned, the key is to use a hole saw, NOT a solid drill. With a hole saw, you are cutting through a lot less metal. With a hole saw it took me one full battery, and a bit of the next one on my 18V cordless. With a solid bit, I'd have been swapping out batteries much more frequently.
John Mc