Sorry for the slow response.
Our home was on propane when we bought it. No gas on our street until the year or so after we purchased it (30 year old country house).
We were renting the propane tank ($100/yr) which locked us into one supplier (Suburban Propane) and SB's prices more or less tripled on the last fill ($2 initially up to almost $6 per gallon).
So we decided to switch to gas. Single supplier problem again. Ultimately we plan on having an all electric house but I don't like to discard working appliances so we'll go electric as things wear out. I want the gas connection for the generator though and if we have any ice storms where the temps are down around zero so we can heat with gas using a hybrid heat pump / gas furnace. We had one at our previous house.
The house had a propane instant water heater that had to be replaced so we went with a HPWH. Love it! Have a propane central furnace (split unit) that was converted to gas yesterday. When the upstairs (electric resistance heat) broke down, had a new heat pump installed.
I don't have the numbers for you but the payback ought to be just a few years. This was not a cheap project.
$200 for generator conversion fuel regulator (to do)
$1200 for new HPWH plus $400 install (done) AO Smith
$500 to attach house to gas meter and convert furnace from propane to nat gas (done)
??? convert gas logs for emergency heat (to do)
??? new heater for basement TV area (to do), existing heater is propane only, no convert
$1500 to run gas line across large lot. Gas company would do XXX feet, my cost for the rest (done)
$800 if I have to hire someone to remove the existing propane tank b/c SB charges for that. Think I'll had dig it myself.
ALL that and it is still cheaper than the last fill of our propane tank.
Could have bought a new propane tank for ~$1500 and shopped around for the best propane prices each time it needed a fill.
When we first moved here the generator ran often due to frequent power outages. Not as much lately. Will be nice not to worry the propane will run out due to furnace and generator burning fuel during a weather event.
I am considering a bi-fuel or tri-fuel conversion regulator so we could run the generator off of a BBQ propane bottle in a pinch but not sure I'm committed enough that I want to purchase and fill a 100+ gallon propane tank. The black out problem isn't frequent enough.
Most manufacturers publish an estimated fuel consumption chart that would answer your question about how long a given generator would run on a BBQ tank.