Definition of CONVERT
Converts a numeric value to a different unit of measure.
CONVERT(5.1, "g", "kg")
CONVERT(32, "C", "F")
CONVERT(35.7, "in^2", "m^2")
CONVERT(A1, A2, A3)
CONVERT(value, start_unit, end_unit)
value- the numeric value in
start_unitto convert to
start_unit- The starting unit, the unit currently assigned to
end_unit- The unit of measure into which to convert
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
CONVERTbetween two different categories of
end_unitwill 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.
DATE: Converts a provided year, month, and day into a date.
DATEVALUE: Converts a provided date string in a known format to a date value.
TIME: Converts a provided hour, minute, and second into a time.
TIMEVALUE: Returns the fraction of a 24-hour day the time represents.
In order to use the CONVERT formula, start with your edited Excellentable
Then type in the CONVERT Formula in the area you would like to display the outcome:
Type in the complete CONVERT formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.