Monday, 6 June 2016

CONVERT function.

CONVERT function:

CONVERT function converts a number from one measurement system to another such as inches to centimeters , days into hours etc.

Syntax:
=CONVERT(number, from_unit, to_unit)

Example:
=CONVERT(A2,"day","hr") : Days into Hours
=CONVERT(A2,"day","mn") : Days into Minutes

Below are the units abbreviations:

Thanks

No comments:

Post a Comment