How can I get the total duration of 2 fields?

(0) Share

Report

Posted on by lynp

How can I get the total duration of this 2 field?

Start and End time are both single line of text.

This is my current code:

function GetTotalDuration(executionContext) {

var formContext = executionContext.getFormContext();

var varStartTime = formContext.getAttribute("new_starttime").getValue();
var varEndTime = formContext.getAttribute("new_endtime").getValue();

var varDuration = varEndTime - varStartTime

alert(varDuration);

}

the alert result is 7247:16. This should be 1 hour and 8 mins.

All responses (9)

Answers (1)

Sort by

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

What types of fields new_starttime/new_endtime?
Verified answer

prt33k 6,907 on at

Like (0)

Report
Copy link

Link copied!
try this:

var formContext = executionContext.getFormContext(); var varStartTime = formContext.getAttribute("new_starttime").getValue(); var varEndTime = formContext.getAttribute("new_endtime").getValue(); var startTime= new Date(); startTime.setHours(varStartTime.substr(0,varStartTime.indexOf(":"))); startTime.setMinutes(varStartTime.substr(varStartTime.indexOf(":") 1)); startTime.setSeconds(0); var endTime= new Date(); endTime.setHours(varEndTime.substr(0,varEndTime.indexOf(":"))); endTime.setMinutes(varEndTime.substr(varEndTime.indexOf(":") 1)); endTime.setSeconds(0); var varDuration = endTime- startTime; var hh = Math.floor(varDuration / 1000 / 60 / 60); varDuration -= hh * 1000 * 60 * 60; var mm = Math.floor(varDuration / 1000 / 60); alert(hh ":" mm);
Suggested answer

Sardar Haseeb 25 on at

Like (0)

Report
Copy link

Link copied!

Try this:

var varStartTime = new DateTime(context.getAttribute("new_starttime").getValue());

var varEndTime = new DateTime(context.getAttribute("new_starttime").getValue());

var varDuration=EndTime-StartTime;

alert(varDuration);
lynp 5 on at

Like (0)

Report
Copy link

Link copied!

currently they're single line of text - string. I want them to be decimal so I can calculate them
lynp 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Sardar,

I tried it but did not work.

Thank you
lynp 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Prateek, it is not working if I'm putting it on the whole number or decimal data type. but if single line of text/string it will work. I need the data type field to be whole number or decimal since I will compute all the duration later on.

Thank you
prt33k 6,907 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If it is going to be decimal then what format are you going to store because you cant have semicolon in a decimal - so having "h:m" format wont work?

Thanks,

Prateek
lynp 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Prateek,

Currently this is my sample record. Start time and end time is single line of text or string.

I need to put the duration of start time and end time to decimal which should be 2.00.

Thank you
prt33k 6,907 on at

Like (0)

Report
Copy link

Link copied!

I that case you can simply use toString() to convert the decimal to string and then use '.' instead of ':' in finding indexof