nuBuilder Forum

Code: Select all

function subformTimeSum(subform, fieldname) {

    var totalSeconds = 0;
    var a = Array();
    var sf = nuSubformObject(subform);
    var c = sf.fields.indexOf(fieldname);
    for (var i = 0; i < sf.rows.length; i++) {
        if (sf.deleted[i] == 0) {
            var currentDuration = sf.rows[i][c];
            currentDuration = currentDuration.split(":");
            var hrs = parseInt(currentDuration[0], 10);
            var min = parseInt(currentDuration[1], 10);
            var sec = parseInt(currentDuration[2], 10);
            var currDurationSec = sec + (60 * min) + (60 * 60 * hrs);
            totalSeconds += currDurationSec;
        }
    }

    var hours = Math.floor(totalSeconds / 3600);
    totalSeconds %= 3600;
    var minutes = Math.floor(totalSeconds / 60);
    var seconds = totalSeconds % 60;

    return hours + ":" + minutes + ":" + seconds;
}

Code: Select all

var sumTimes = subformTimeSum('subform_object_id', 'time_object_id');
$('#totalTime').val(sumTimes);