Is it possible to track weight in pounds and oz?
Ideally, I would like to use a formula to track the difference between two weights. (i.e. The difference between 8 lbs 2.6 oz and 8 lbs 4.1 oz. is 1.5 oz).
If pounds and oz are not possible, is it possible I use a formula to convert to/from grams so I can also use the weight data in a chart/graph ux?
A possible way to do this is to have 3 columns:
lbs1, oz1, converted1.
Converted1 would calculate the value of lbs.X16
and add the value in oz1 for the first weight.
So the converted field would have total equivalent in ounces. Another column for converted2 would do the same for the second weight lbs2, oz2.
Subtract converted 1 from converted 2 to get the difference and chart the difference column.
These additional columns should probably be virtual columns and then you can pick up the results and put it into a set of lbs &
ozs. for the difference.
Thank you, @Mary_Jane_Pender for the suggestion.
If you aren’t in a hurry for instant results in app, Google Sheets has lots of conversion formulas that could likely do everything you want in the back end
DB, you’d just have to wait for the Sync. From Google CONVERT Site: CONVERT Converts a numeric value to a different unit of measure.
Sample Usage CONVERT(5.1, “g”, “kg”)
CONVERT(32, “C”, “F”)
CONVERT(35.7, “in^2”, “m^2”)
CONVERT(A1, A2, A3)
Syntax CONVERT(value, start_unit, end_unit)
value - the numeric value in start_unit to convert to end_unit
start_unit - The starting unit, the unit currently assigned to value .
end_unit - The unit of measure into which to convert value.
Notes The following list outlines the available unit conversions by category:
Weight - u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton
Distance - ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec
Time - sec, min, hr, day, yr
Pressure - Pa, mmHg, Torr, psi, atm
Force - dyn, pond, N, lbf
Energy - eV, e, J, flb, c, cal, BTU, Wh, HPh
Power - W, PS, HP
Magnetism - ga, T
Temperature - C, F, K, Rank, Reau
Volume - ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3
Area - ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2
Information - bit, byte
Speed - m/hr, mph, kn, admkn, m/s
The use of CONVERT between two different categories of start_unit and end_unit will result in an error. For example, CONVERT(13.2,“ft”,“C”) would result in an error as a result of an attempted conversion from distance units to temperature units.
See Also DATE: Converts a year, month, and day into a date.
DATEVALUE: Converts a provided date string in a known format to a date value.
TIME: Converts an hour, minute, and second into a time.
TIMEVALUE: Returns the fraction of a 24-hour day the time represents.
Examples The following example shows CONVERT between different sample start_unit and end_unit arguments.
CONVERT - Docs editors Help support.google.com