How are data types converted?

Numerical data types are automatically converted to the matching data type that serves as the input value for a function.

When calculating, you can mix value units, for example, use a duration in days, hours, and minutes in a formula. The units are converted during the calculation and the result is shown in the appropriate unit.

A conversion is also carried out if the result is a very large number and an appropriate unit is available. For example, 1000 minutes is 16 hours and 40 minutes.

All conversions are also available for conditional formatting.