Duration Format

Custom Duration Format

Zoho Analytics allows you to use and display the time duration period in various formats. This document explains the various time duration formats available, and how to construct them.

Customizing Duration Format  

You can customize the duration format at the Workspace level or at the Table level. 

Strings

The following table lists the supported strings to construct the duration format.

StringMeaning
Seconds
%sDuration in seconds
%SSSDuration in milliseconds
%SSSSSSDuration in microseconds
Minutes
%mDuration in Minutes
Hours
%HDuration in Hours
Days
%DDuration in Days

Separators

You can use any element as a separator for duration. You can also use a different separator for each element. The following are a few examples of standard patterns.

  • 45 days 18 hrs 31 mins 27 secs
  • 45 days 18:31:27
  • 45 days 18.31.27
  • 45.18:31:27

Formats

The following table lists examples of custom duration format.

FormatExample
Single Element
%s13456829
%s Sec13456829 Sec
%SSS586
%SSS Millisecond586 Millisecond
%SSSSSS586709
%SSSSSS Microsecond586709 Microsecond
%m86
%m mins86 mins
%H234
%H hrs234 hrs
%D45
%D days45 days
Seconds And Millisecond or Microsecond
%s.%SSS13456829.586
%s.%SSSSSS13456829.586709
Hours and Minutes
%H:%m234:33
%H.%m234.33
%H hrs %m mins234 hrs 33 mins
%H/%m234/33
Hours, Minutes and Seconds​
%H:%m:%s234:33:44
%H.%m.%s234.33.44
%H hrs %m mins %s secs234 hrs 33 mins 44 secs
%H h %m m %s s234 h 33 m 44 s
%H/%m/%s234/33/44
Days and Hours
%D:%H45:18
%D.%H45.18
%D Days %H hrs45 days 18 hrs
%D/%H45/18
Days, Hours, Minutes and Seconds
%D:%H:%m:%s45:18:31:27
%D.%H.%m.%s45.18.31.27
%D days %H hrs %m mins %s secs45 days 18 hrs 31 mins 27 secs
%D/%H/%m/%s45/18/31/27
%D Days %H:%m:%s45 days 18:31:27
%D.%H:%m:%s.%SSSSSS45.18:31:27.586709
In Swap Position
%m mins %H hrs %D days31 mins 18 hrs  45 days

 

Note: While importing duration data into Zoho Analytics, ensure the duration format is specified as in your source data. You can later change this in your table as needed.

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohoanalytics.com