Want to convert a number field into hh:mm:ss in a calculation field

Follow

Jayraj Berde

• June 19, 2017 14:11

Hi Guys,

I am pulling call duration from Ringcentral in a app. But it does not show the call length in hh:mm:ss instead it shows in seconds only. Now I want to calculate this seconds number and divide it by 86400 seconds and display it in a HH:MM:SS format. 

Can anyone help me with the calculation for the same

0

• 

  Jayraj Berde

  • June 19, 2017 14:12

  I don't have a start date and a end date & time here. I just have the number of seconds available to calculate. 

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • June 19, 2017 15:04

  Hi Jayraj

  this should do it:

  var secTotal = @duration;
  var secHr = 3600;
  var secMin = 60;
  hr = parseInt(secTotal/secHr);
  min = parseInt((secTotal%secHr)/secMin);
  sec =parseInt((secTotal%secHr)%secMin);
  hr + ":" + min + ":" + sec

  Rainer

  0

  Comment actions Permalink
• 

  Jayraj Berde

  • June 20, 2017 12:53

  Thanks Rainer, you are the man. Works perfectly.

  0

  Comment actions Permalink

Please sign in to leave a comment.