PowerUp Description
The pwrCONVERTTIME PowerUp function converts a number with a given unit to an equivalent number in another unit. Many common units are included ranging from nanoseconds to years. Some less common such as dog years and cat years are also included.
PowerUp Syntax
pwrCONVERTTIME(value, SourceUnit, TargetUnit)
The pwrCONVERTTIME PowerUp function has the following arguments:
value – Required. This is the number you will be converting.
SourceUnit – Required. This is a value that represents the source unit which are detailed below.
TargetUnit – Required. This is a value that represents the target unit to which the conversion will be done. Any combination of the argument values below can be used.
YR – Year
MO – Month
WK – Week
DAY – Day
HR – Hour
MIN – Minute
SEC – Second
MIL – Millisecond
MIC – Microsecond
NAN – Nanosecond
DOG – Dog Year
CAT – Cat Year
Return Value
pwrCONVERTTIME will return an equivalent number of SourceUnit expressed in TargetUnit.
Remarks
For some of the very large or high precision numbers, the possibility for round off errors exists. Always verify the returned values.
Example
=pwrCONVERTTIME(A1,"yr","dog")
