View the original community article here
Last Tested: Jan 21, 2019
If your value is a number of seconds, divide the number by 86400.0 (the number of seconds in a day) and then use the value format
NOTE that this is like a time, and will show you the 24-hour time modded by day. So if you had 25 hours, it would show
01:00:00 rather than
25:00:00. You can use the day modifier
dd:hh:mm:ss to include days, or use sql as described in this community post.
Table calcs can get at this too - where
my_time_difference is in seconds:
" hours, ",
" minutes, ",
This content is subject to limited support.