Find Time Average Of Hh:mm:ss

I have this fiddle that calculates average time with miliseconds. However, my DB stores data in format of hh:mm:ss. fiddle var times= [ '00:00:03.00', '00:00:05.00', '00:00:02.00',

Solution 1:

You could get the seconds, round the value and build a new string of the average time.

function getAverageTime(array) {
    var times = [3600, 60, 1],
        parts = array.map(s => s.split(':').reduce((s, v, i) => s + times[i] * v, 0)),
        avg = Math.round(parts.reduce((a, b) => a + b, 0) / parts.length);

    return times
        .map(t => [Math.floor(avg / t), avg %= t][0])
        .map(v => v.toString().padStart(2, 0))
        .join(':');
}

console.log(getAverageTime(['00:00:03', '00:00:05', '00:00:020', '00:00:07']));
console.log(getAverageTime(['00:00:03', '00:30:05', '00:30:020', '03:00:07']));

ES5

function getAverageTime(array) {
    var times = [3600, 60, 1],
        parts = array.map(function (s) {
            return s.split(':').reduce(function (s, v, i) {
                return s + times[i] * v;
            }, 0);
        }),
        avg = Math.round(parts.reduce(function (a, b) {
            return a + b;
        }, 0) / parts.length);

    return times
        .map(function (t) {
            var value = Math.floor(avg / t);
            avg %= t;
            return value;
        })
        .map(function (v) {
            return v.toString().padStart(2, 0);
         })
        .join(':');
}

console.log(getAverageTime(['00:00:03', '00:00:05', '00:00:020', '00:00:07']));
console.log(getAverageTime(['00:00:03', '00:30:05', '00:30:020', '03:00:07']));

Solution 2:

var seconds = avg.getMilliseconds() > 500 ? avg.getSeconds() + 1 : avg.getSeconds();

result = offsetify(avg.getHours()) + ':' + offsetify(avg.getMinutes()) + ':' + 
offsetify(seconds);

Basically just checking to see if ms is more than 50, if it is can manually add one to seconds, if not leave seconds as is. Not sure if you wanted seconds to be offset as well.

Solution 3:

Date can be used to convert them to milliseconds :

function averageTime(arr) {
    var sum = arr.reduce(function(a, b) { return a + +new Date('1970T' + b + 'Z'); }, 0);
    return new Date(sum / arr.length + 500).toJSON().slice(11, 19);
}

console.log( averageTime(['00:00:03.00', '00:00:05.00', '00:00:02.00', '00:00:06.00']) );
console.log( averageTime(['00:00:03', '00:00:05', '00:00:20', '00:00:07']) );

Solution 4:

First, convert all times into their UNIX timestamps using Date.getTime(), producing an array, then average the results. example: ]

let times = [
1551984787316,
1551984789662,
1551984790162,
1551984790730,
1551984791310
]


let average = ( values ) => {
  let sum = 0;
  for( let i = 0; i < values.length; i++ ){
    sum += parseInt( values[i], 10 ); // base 10
  }

  return Math.floor( sum/values.length );
}

let avgTime = average( times );
let avgDate = new Date( avgTime );
console.log( avgDate );