Format String | Description | Range |
D | Indicates the Days | 0 to 36500000 |
H | Indicates the Hours | 00 to 23 Note: The range for duration in hours is 0 to 876000000 |
m | Indicates the Minutes | 00 to 59 |
s | Indicates the Seconds | 00 to 59 Note: The range for duration in seconds is 0 to 3153600000000 |
SSS | Indicates the Milliseconds | 00 to 999 |
SSSSSS | Indicates the Microseconds | 0 to 999999 |
Formats | Examples |
%H:%m:%s | 301.21:12:00 |
%H:%m:%s.%SSS | 301.21:12:00.321 |
%H:%m:%s.%SSSSSS | 201 11:12:21.000001 |
%H hrs %m mins %s secs | 11 hrs 12 mins 21 secs |
%H hours %m minutes %s seconds %SSSSSS | 1 hours 2 minutes 1 seconds 910001 |
%s | 222222345678 |
%s.%SSS | 1234523.156 |
%s.%SSSSSS | 12345.999999 |
Formats | Example |
%D %H:%m:%s | 201 11:12:21 |
%D %H:%m:%s.%SSS | 201 11:12:21.91 |
%D days %H:%m:%s.%SSSSSS | 201 days 11:12:21.000111 |
%D days %H hrs %m mins %s secs | 201 days 11 hrs 12 mins 21 secs |
%D days %H hrs %m mins %s secs %SSS | 10092 days 11 hrs 12 mins 21 secs 901 |
%D days %H hours %m minutes %s seconds %SSSSSS | 12 days 1 hours 2 minutes 1 seconds 910001 |
%D days %H hours %m minutes %s seconds %SSS | 12 days 1 hours 2 minutes 1 seconds 910 |
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com