Convert Duration field into Hours and Minutes

[Alon Grod]

Hi,

i have the field u_duration of type duration.

I need to populate a the field u_time of type String with the hours and the minutes from the duration field using on update Business Rule.

For example,

Duration: 02:24:30. (Days: Hours: Minutes )

Time: 72:30 (Hours:Minutes)

The answer should always be Hours:Minutes 

[Dr Atul G- LNG]

Hi @Alon Grod 

https://www.servicenow.com/community/developer-forum/how-to-convert-duration-field-days-hours-minute...

https://www.servicenow.com/community/developer-forum/convert-duration-into-minute/m-p/1482599

[Sohail Khilji]

@Alon Grod , 

Try this,

var inputTime = "02:24:30"; //example

var timeComponents = inputTime.split(':');
var days = parseInt(timeComponents[0]);
var hours = parseInt(timeComponents[1]);
var minutes = parseInt(timeComponents[2]);

var totalHours = days * 24 + hours;

var outputTime = "Time: " + totalHours + ":" + minutes + " (Hours:Minutes)";

gs.info(outputTime);