Convert Milliseconds to business days

[SM16]

Hi Team - I have the below script which returns the duration for performing certain activities. This duration is in milliseconds or full days.

Example: If you convert milliseconds - 486000000 into hours you get 135 hours. If you divide 135 by 9, it gives 15. Final outcome must be 15 Days. Output can come to any given value and must be Minutes, hours, or days

Like 15 minutes, 1 Hour or can be 5 days 2 hours, 15 minutes

var grScCatItem = new GlideRecord('sc_cat_item');
grScCatItem.get('5d9c4b3c1b154c90e7d6202e6e4bcb1e')
var duration = grScCatItem.getValue('delivery_time');
gs.print(duration);
		var gdt = new GlideDateTime(duration);
        gs.print(gdt.getNumericValue());
		var dur = new GlideDuration(gdt.getNumericValue());
		var days = dur.getDisplayValue();
		gs.print(days);

*** Script: 1970-01-06 15:00:00
*** Script: 486000000
*** Script: 5 Days 15 Hours

[Saurabh Gupta]

Hi,
You can do as per below script

function millisecondsToDuration(millisecond){
  var oneDayInMilliseconds = 9 * 60 * 60 * 1000;
  var totalDays = Math.floor(milliseconds / oneDayInMilliseconds);
  var remainingMilliseconds = milliseconds % oneDayInMilliseconds;
  var hours = Math.floor(remainingMilliseconds / (60 * 60 * 1000));
  remainingMilliseconds %= 60 * 60 * 1000;
  var minutes = Math.floor(remainingMilliseconds / (60 * 1000));
  remainingMilliseconds %= 60 * 1000;
  var seconds = Math.floor(remainingMilliseconds / 1000);


  var duration = {
    days: totalDays,
    hours: hours,
    minutes: minutes,
    seconds: seconds
  };

  return duration;
}

// Example usage:
var msg="";
var milliseconds = 486450000; // Replace this with your desired milliseconds
var result = millisecondsToDuration(milliseconds);
if(result.days)
{
msg+=result.days+" Days "+ result.hours+" Hours "+ result.minutes+" Minutes "+ result.seconds+" Seconds ";
}
else if(result.hours)
{
msg+=result.hours+" Hours "+ result.minutes+" Minutes "+ result.seconds+" Seconds ";
}
else if(result.minutes)
{
msg+=result.minutes+" Minutes "+ result.seconds+" Seconds ";
}
else
{
msg+=result.seconds+" Seconds ";
}
gs.info(msg)

[Saurabh Gupta]

Hi,

[Saurabh Gupta]

Hi @SM16