CommencerCommencez gratuitement

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.

Cet exercice fait partie du cours

<cours>Google Sheets intermédiaire</cours>
Voir le cours

Instructions de l’exercice

  • In column H, convert the times in column A from seconds to minutes.
  • In column I, convert the wind speeds in column B from meters per second to miles per hour.

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice