So I live in Hardy, born and raised, made the drive a thousand times. If you are coming from Nanaimo/Duke Point your looking at 4 hours from Horseshoe Bay, 4.5 from Duke Point. A quick pit stop in Campbell River for fuel and take care of business. Of course if you stop for lunch and things like that it will take you longer, if your looking for drive time that's what it takes. Coming from Vic add add 1.5. Fantastic drive, highway is great, tons of wildlife, not a bunch of traffic very relaxing drive, well worth the trip if you are looking for some fantastic scenery and check out an amazing part of the Island.
Feel free to send me an email if you would like more info.
Cheers!