LoslegenKostenlos starten

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.

Diese Übung ist Teil des Kurses

<Kurs>Google Sheets: Fortgeschrittene Funktionen</Kurs>
Kurs ansehen

Übungsanweisungen

  • 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.

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis

Übung starten