Converting Ounces to Gallons

[Holganix]

I could use a little help converting Ounces into Gallons. My problem is that I use this formula =convert(A1,"oz","gal") and it works great but gives me answers like 7.6 I need something that takes ounces and converts to gallons with the remaining showing in ounces. That 7.6 would read 7 gallons 77 ounces.

 

[jim may]

Does this help?

Excel Workbook
	A	B	C
1	Ounces	Gallons	Whole Gallons & Ounces
2	973	7.601563	7 gallons and 77 ounces
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B2	=A2/128
C2	=INT(B2)&" gallons and "&(B2-INT(B2))*128 & " ounces"

 

[Ruddles]

Is that a stingy American gallon or a proper UK gallon?

http://en.wikipedia.org/wiki/Gallon

 

[shg]

You could use

=DOLLARFR(A1/128, 128)

For A1 = 973, returns 7.077