How to display the Second difference in an indicator widget in hh:mm:ss?

Help and How-To

I have an indicator widget where my formula in the indicator widget goes as follows:

SUM(SDiff([Hours in pickup_datetime],[Hours in dropoff_datetime]))

I want the widget to display the difference in hh:mm:ss seconds. Is there a way to do this in the script editor?

DRay intapiuser

Rafael Ferreira

Posted 2 years ago·Last reply 2 years ago

1 comment

Rafael Ferreira

OP2 years ago

This is from an old post but this seems to have worked for me utilizing this code. Would love to see if this works for other people to confirm.

widget.on('processresult', function (s,e){<br/><br/>function convertRawTime(num){<br/> <br/> var sign = num < 0 ? '-' : '';<br/> var hours = (parseInt( Math.abs(num) / 3600 )%24);<br/> var minutes = parseInt( Math.abs(num) / 60 )%60;<br/> var seconds = parseInt( Math.abs(num) % 60);<br/><br/> var hoursText = hours < 10 ? "0" + hours : hours;<br/> var minutesText = minutes < 10 ? "0" + minutes : minutes;<br/> var secondsText = seconds < 10 ? "0" + seconds : seconds;<br/> if (hours==0){<br/>   var secondsText = seconds < 10 ? "0" + seconds : seconds;<br/>   return sign + minutes + ":" + secondsText<br/> } else {<br/>   var hoursText = hours < 10 ? "0" + hours : hours;<br/>   var minutesText = minutes < 10 ? "0" + minutes : minutes;<br/>   var secondsText = seconds < 10 ? "0" + seconds : seconds;<br/>   return sign + hoursText + ":" + minutesText + ":" + secondsText<br/><br/> }<br/> };<br/> <br/> // update the primary indicator<br/> e.result.value.text=convertRawTime(e.result.value.data);<br/> <br/> // update the secondary indicator, if there is one<br/> if (e.result.hasOwnProperty('secondary')) {<br/>    e.result.secondary.text=convertRawTime(e.result.secondary.data);<br/> }<br/><br/>});