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.


For some of the very large or high precision numbers, the possibility for round off errors exists. Always verify the returned values.



Leave a Reply

Your email address will not be published. Required fields are marked *