Knowledge Drop

How can I display a decimal number in hh:mm:ss format?

  • 6 April 2021
  • 0 replies

Userlevel 3

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 hh🇲🇲ss.

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:

concat (


" hours, ",


" minutes, ",


" seconds."



This content is subject to limited support.                



0 replies

Be the first to reply!