secsminshours(
TIME
)

The secsminshours( function this converts a time (number of seconds) into an approximate text value.


Parameters

This function has one parameter:

time – the number of seconds.


Description

This converts a time (number of seconds) into an approximate text value. The time is rounded to the nearest unit level: seconds, minutes, hours, or days. For example 3 will be 3 converted to seconds, 63 will be converted to 1 minute, 3700 will be converted to 1 hour, etc.

secsminshours(1200) ☞ 20 minutes
secsminshours(12000) ☞ 3 hours
secsminshours(1200000) ☞ 14 days

Note: This function is equivalent to:

?(time<60,pattern(time,"# second~"),?(time<3600,pattern(time/60,"# minute~"),?((time<3600*24),
    pattern(time/3600,"# hour~"),pattern(time/86400,"# day~"))))

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.