Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal in imperial weight
Hi
I have a number, say 312.08 that I want to divide by say 24 and report as weight in pounds and ounces simple division reports 13.0333 -- thanks in anticipation Roy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal in imperial weight
From a Google search this post from Gary's Student:
With kilos in A1, In B1 & C1: =ROUND(convert(A1,"kg","lbm"),0) =ROUND(16*(convert(A1,"kg","lbm")-B1),0) so 17 kilos will show as 37 lbs 8 ozs -- Gary''s Student - gsnu200854 -- Kind regards, Niek Otten Microsoft MVP - Excel "Roy Gudgeon" wrote in message ... Hi I have a number, say 312.08 that I want to divide by say 24 and report as weight in pounds and ounces simple division reports 13.0333 -- thanks in anticipation Roy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal in imperial weight
That should be 13.00333.
The worksheet function "Convert" could be used or with the result of your division in cell A1 then... =INT(A1)&" pounds and " &ROUND((A1-INT(A1))*16,2)&" ounces" -- Jim Cone Portland, Oregon USA "Roy Gudgeon" wrote in message ... Hi I have a number, say 312.08 that I want to divide by say 24 and report as weight in pounds and ounces simple division reports 13.0333 -- thanks in anticipation Roy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal in imperial weight
In A1:
=321.08/24 displays the lbs (fractional) In B1: =INT(A1) displays integer lbs In C1: =CONVERT(A1-B1,"lbm","ozm") displays the residual ozs. -- Gary''s Student - gsnu200860 "Roy Gudgeon" wrote: Hi I have a number, say 312.08 that I want to divide by say 24 and report as weight in pounds and ounces simple division reports 13.0333 -- thanks in anticipation Roy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert decimal in imperial weight
perfect Jim, thanks to you and the other respondees
-- thanks Roy "Jim Cone" wrote: That should be 13.00333. The worksheet function "Convert" could be used or with the result of your division in cell A1 then... =INT(A1)&" pounds and " &ROUND((A1-INT(A1))*16,2)&" ounces" -- Jim Cone Portland, Oregon USA "Roy Gudgeon" wrote in message ... Hi I have a number, say 312.08 that I want to divide by say 24 and report as weight in pounds and ounces simple division reports 13.0333 -- thanks in anticipation Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function To Convert Liters To Imperial Gallons & Vice Versa | Excel Worksheet Functions | |||
What is the Formula to Convert Imperial to Metric Measurements | Excel Worksheet Functions | |||
How do I convert imperial to metric in Exel? | Setting up and Configuration of Excel | |||
Imperial weight | Charts and Charting in Excel | |||
How do I use Excel's convert function for apothecary weight? | Excel Worksheet Functions |