TIMESPAN

This is the help page for my TIMESPAN function in Google Apps Scripts gallery.

The code:

/*

* Return the timespan between two dates.

* To be used for calculating the length of a workday - hours and minutes.

*/

function TIMESPAN(t1,t2){

var h1 = t1.getHours();

var m1 = t1.getMinutes();

var h2 = t2.getHours();

var m2 = t2.getMinutes();

var diff = Math.abs((h1 * 60 + m1) - (h2 * 60 + m2));

var m = diff % 60;

var h = (diff - m) / 60;

var ret = new Date();

ret.setMinutes(m);

ret.setHours(h);

ret.setSeconds(0);

return ret;

}

function TIMESPAN_example(){

var d1 = new Date(2013,8,8,07,0,0);

var d2 = new Date(2013,8,8,16,0,0);

Logger.log(TIMESPAN(d2,d1));

}