This is a LOT easier with format_value - measure: time_hours type: number sql: ${time_seconds} / 86400.0 value_format: "h:mm:ss" Your value needs to be in number of days (hence the divide by 86400.0 to get from seconds to days) you can even use this ...