Hi Marc, The formatDuration function takes a duration in milliseconds and returns a formatted duration in the form "days HH:mm:ss" For example, formatDuration(443707000) takes the duration in milliseconds and returns "5d 03:15:00"
Dhatri Misra Thank you. I tried this with my second data and multiplied it by 1000 to convert to milliseconds and it isn't quite right. For example, I have raw data of 82 seconds. When using 82000 as the parameter, I get 00:01:00. I expect 00:01:22.
I have manually implemented this using a formula that gives me exactly what I expect. This is the formula. It is quite extensive.