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.

I have the same question (0)

All responses (9)

Answers (1)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: How can I get the total duration of 2 fields?

Hello,

What types of fields new_starttime/new_endtime?

Was this reply helpful? Yes No
Verified answer

prt33k 6,907 on at

Like (0)

Report
RE: How can I get the total duration of 2 fields?

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);

Was this reply helpful? Yes No
Suggested answer

Sardar Haseeb 25 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

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);

Was this reply helpful? Yes No
lynp 5 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

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

Was this reply helpful? Yes No
lynp 5 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

Hi Sardar,

I tried it but did not work.

Thank you

Was this reply helpful? Yes No
lynp 5 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

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

Was this reply helpful? Yes No
prt33k 6,907 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

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

Was this reply helpful? Yes No
lynp 5 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

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

Was this reply helpful? Yes No
prt33k 6,907 on at

Like (0)

Report

RE: How can I get the total duration of 2 fields?

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

Was this reply helpful? Yes No