Calculate time difference in minutes

Santhana Rajhan · ‎12-27-2017

I want a field to display the difference between two times in minutes.

Eg: Business Duration = 136

Prateek kumar · ‎12-27-2017

Hello Santhana

Please try below. g_form doesnot work server side

(function calculatedFieldValue(current) {

var dateString1 = new GlideDateTime(current.begin); //make sure variable name is begin

var dateString2 = new GlideDateTime(current.end); // make sure variable name is end

var diffSeconds = gs.dateDiff(dateString1, dateString2, true);

diffMins = diffSeconds/60;

return Math.round(diffMins); // return the calculated value

})(current);

Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Santhana Rajhan · ‎12-27-2017

The rule didnt work. The type of the Business Duration field is an integer. Is that a problem?

vikkyk · ‎12-24-2025

To calculate the time difference between two Date/Time fields in minutes, use a GlideDateTime difference and convert it to minutes:

var gdtStart = new GlideDateTime(current.begin);
var gdtEnd = new GlideDateTime(current.end);

// Difference in milliseconds
var diff = gdtEnd.getNumericValue() - gdtStart.getNumericValue();

// Convert ms → minutes
var minutes = diff / 1000 / 60;

current.u_business_duration = minutes;

Begin: 2017-12-26 07:39:52
End: 2017-12-26 09:55:52

Difference: 2 hours 16 minutes = 136 minutes