Preaching to the CONVERT()ed
CONVERT(), changes the units of a number. For times, you have five choices of unit to switch between, including
"sec": seconds"min": minutes
For speeds, the units include
"m/s": meters per second"mph": miles per hour
CONVERT() takes three arguments: a number or cell address, the existing unit (in double quotes), and the unit to convert to. For example, CONVERT(1, "hr", "sec") returns 3600.
Toto cvičení je součástí kurzu
Intermediate Google Sheets
Pokyny k cvičení
- In column
H, convert the times in columnAfrom seconds to minutes. - In column
I, convert the wind speeds in columnBfrom meters per second to miles per hour.
Interaktivní praktické cvičení
Proměňte teorii v praxi s jedním z našich interaktivních cvičení
Začít cvičení