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.