How to quickly convert formula
|
|
|
|
|
|
|
|
|
|
|
|
Amount
To Convert
|
Converting
From
|
Converting
To
|
Converted
Amount
|
|
|
|
|
|
1
|
in
|
cm
|
2.54
|
=CONVERT(C4,D4,E4)
|
|
|
|
|
1
|
ft
|
m
|
0.3048
|
=CONVERT(C5,D5,E5)
|
|
|
|
|
1
|
yd
|
m
|
0.9144
|
=CONVERT(C6,D6,E6)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1
|
yr
|
day
|
365.25
|
=CONVERT(C8,D8,E8)
|
|
|
|
|
1
|
day
|
hr
|
24
|
=CONVERT(C9,D9,E9)
|
|
|
|
|
1.5
|
hr
|
mn
|
90
|
=CONVERT(C10,D10,E10)
|
|
|
|
|
0.5
|
mn
|
sec
|
30
|
=CONVERT(C11,D11,E11)
|
|
|
|
|
|
|
|
|
|
|
|
|
What
Does It Do ?
|
|
|
|
|
|
|
|
|
This
function converts a value measure in one type of unit, to the same value
expressed
|
||||||
|
|
in a
different type of unit, such as Inches to Centimetres.
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
|
|
=CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo)
|
|
|||||
|
|
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
|
|
No
special formatting is needed.
|
|
|
|
|
||
|
|
|
|
|
|
|
|
|
|
|
Example
|
|
|
|
|
|
|
|
|
The
following table was used by an Import / Exporting company to convert the
weight
|
||||||
|
|
and
size of packages from old style UK measuring system to European system.
|
|
|||||
|
|
|
|
|
|
|
|
|
|
|
|
|
Pounds
|
Ounces
|
Kilograms
|
|
|
|
|
|
Weight
|
5
|
3
|
2.35301
|
|
|
|
|
|
|
|
|
=CONVERT(D28,"lbm","kg")+CONVERT(E28,"ozm","kg")
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
Feet
|
Inches
|
Metres
|
|
|
|
|
|
Height
|
12
|
6
|
3.81
|
|
|
|
|
|
Length
|
8
|
3
|
2.5146
|
|
|
|
|
|
Width
|
5
|
2
|
1.5748
|
|
|
|
|
|
|
|
|
=CONVERT(D34,"ft","m")+CONVERT(E34,"in","m")
|
||
|
|
|
|
|
|
|
|
|
|
|
Abbreviations
|
|
|
|
|
|
|
|
|
This is
a list of all the possible abbreviations which can be used to denote
measuring systems.
|
||||||
|
|
|
|
|
|
|
|
|
|
|
Weight
& Mass
|
|
|
Distance
|
|
|
|
|
|
Gram
|
g
|
|
Meter
|
m
|
|
|
|
|
Kilogram
|
kg
|
|
Statute
mile
|
mi
|
|
|
|
|
Slug
|
sg
|
|
Nautical
mile
|
Nmi
|
|
|
|
|
Pound
mass
|
lbm
|
|
Inch
|
in
|
|
|
|
|
U
(atomic mass)
|
u
|
|
Foot
|
ft
|
|
|
|
|
Ounce
mass
|
ozm
|
|
Yard
|
yd
|
|
|
|
|
|
|
|
Angstrom
|
ang
|
|
|
|
|
Time
|
|
|
Pica
(1/72 in.)
|
Pica
|
|
|
|
|
Year
|
yr
|
|
|
|
|
|
|
|
Day
|
day
|
|
Pressure
|
|
|
|
|
|
Hour
|
hr
|
|
Pascal
|
Pa
|
|
|
|
|
Minute
|
mn
|
|
Atmosphere
|
atm
|
|
|
|
|
Second
|
sec
|
|
mm of
Mercury
|
mmHg
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Temperature
|
|
|
Liquid
|
|
|
|
|
|
Degree
Celsius
|
C
|
|
Teaspoon
|
tsp
|
|
|
|
|
Degree
Fahrenheit
|
F
|
|
Tablespoon
|
tbs
|
|
|
|
|
Degree
Kelvin
|
K
|
|
Fluid
ounce
|
oz
|
|
|
|
|
|
|
|
Cup
|
cup
|
|
|
|
|
Force
|
|
|
Pint
|
pt
|
|
|
|
|
Newton
|
N
|
|
Quart
|
qt
|
|
|
|
|
Dyne
|
dyn
|
|
Gallon
|
gal
|
|
|
|
|
Pound
force
|
lbf
|
|
Liter
|
l
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Energy
|
|
|
Power
|
|
|
|
|
|
Joule
|
J
|
|
Horsepower
|
HP
|
|
|
|
|
Erg
|
e
|
|
Watt
|
W
|
|
|
|
|
Thermodynamic
calorie
|
c
|
|
|
|
|
|
|
|
IT
calorie
|
cal
|
|
Magnetism
|
|
|
|
|
|
Electron
volt
|
eV
|
|
Tesla
|
T
|
|
|
|
|
Horsepower-hour
|
HPh
|
|
Gauss
|
ga
|
|
|
|
|
Watt-hour
|
Wh
|
|
|
|
|
|
|
|
Foot-pound
|
flb
|
|
|
|
|
|
|
|
BTU
|
BTU
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
These
characters can be used as a prefix to
access further units of measure.
|
|
|||||
|
|
Using
"c" as a prefix to meters "m" will allow
centimetres "cm" to be calculated.
|
|
|||||
|
|
|
|
|
|
|
|
|
|
|
Prefix
|
Multiplier
|
Abbreviation
|
|
Prefix
|
Multiplier
|
Abbreviation
|
|
|
exa
|
1.00E+18
|
E
|
|
deci
|
1.00E-01
|
d
|
|
|
peta
|
1.00E+15
|
P
|
|
centi
|
1.00E-02
|
c
|
|
|
tera
|
1.00E+12
|
T
|
|
milli
|
1.00E-03
|
m
|
|
|
giga
|
1.00E+09
|
G
|
|
micro
|
1.00E-06
|
u
|
|
|
mega
|
1.00E+06
|
M
|
|
nano
|
1.00E-09
|
n
|
|
|
kilo
|
1.00E+03
|
k
|
|
pico
|
1.00E-12
|
p
|
|
|
hecto
|
1.00E+02
|
h
|
|
femto
|
1.00E-15
|
f
|
|
|
dekao
|
1.00E+01
|
e
|
|
atto
|
1.00E-18
|
a
|
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment