Convert Elapsed Time in ArcGIS Dashboards

Question

Does anyone know if there is a way to convert a known length of time (in this case the number of minutes estimated for a sewer overflow) to hours, minutes, and seconds?  Currently I am displaying the number of minutes (stored in a double field in a feature service) as an indicator in my dashboard.  Any suggestions would be greatly appreciated.

Philip_Ohlinger · Answer

Is there a way to do this on a dashboard with a conditional indicator (based on a calculation?) I have indicators that show the 90th percentile time, and will be green or red depending on if it is over the benchmark or not. The data is stored in a double field as minutes, but ultimately we'd love to display the times on the dashboard in the hh:mm:ss format. Not sure if this is possible?

Dashboard.png

shildebrand · Answer

Thanks Josh, that was exactly what I was looking for!  I appreciate your time and effort on this!

jcarlson · Answer

Ah, you mean like "2 hours, 26 minutes, 15 seconds". That would have to be an arcade expression. For an example, I'll use 137.9 minutes. This is using a feature-based indicator with Arcade enabled.

var dur = $datapoint['duration-field'] // 137.9 used for test
var s = (dur * 60) % 60
var m = Floor(dur) % 60
var h = (Floor(dur) - m) / 60

return {
    topText: `${dur} minutes`,
    topTextMaxSize: 'medium',
    middleText: `${h} hours, ${m} minutes, ${s} seconds`,
    middleTextMaxSize: 'large'
  }

Which results in: