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.

Format Column

Zoho Analytics auto identifies the data type and its format while importing. Ensure the duration format is displayed as in your source data. You can also change this format when needed.

  1. Right- click the duration column and select Format Column from the drop- down menu.
  2. In the Fomat column dialog that opens, Choose the Alignment
  3. Choose the preferred format from  the list or enter the duration format in the given field.

Edit Duration Values

Follow the below steps to edit a column that has duration values:

  1. Double - click on any cell that contains duration data.
  2. Click the Duration icon and modify the values as needed. You can also view the full duration value, irrespective of the format chosen.