0 Replies Latest reply on Aug 16, 2017 12:44 PM by alphataz

# Calculate the differerence in time for over 24 hour period using military time.

I would like to be able to cross the 23:59 time span. Using Acrobat Pro XI.

Result as decimal: Field: 'Time5Dec.5'

event.value = '';

// get the start time

var sStart = this.getField('TimeIn.5').value;

// get the end time

var sEnd = this.getField('TimeOut.5').value;

// complete script only if we have data

if(sStart != '' & sEnd != '') {

// convert sStart string to seconds

var fStart = Time2Num('hh:mm', sStart);

// convert sEnd string to seconds

var fEnd = Time2Num('hh:mm', sEnd);

// compute difference in seconds

var fDiff = fEnd - fStart;

// convert to rounded minutes

fDiff = Math.round(fDiff / 60);

// report decimal hours

event.value = fDiff / 60;

}

Result as HH:MM Field: 'TimeHHMM.5'

event.value = '';

// get the start time

var sStart = this.getField('TimeIn.5').value;

// get the end time

var sEnd = this.getField('TimeOut.5').value;

// complete script if we have data

if(sStart != '' & sEnd != '') {

// convert sStart string to seconds

var fStart = Time2Num('hh:mm', sStart);

// convert sEnd string to seconds

var fEnd = Time2Num('hh:mm', sEnd);

// convert sEnd string to seconds

var fEnd = Time2Num('hh:mm', sEnd);

// compute difference in seconds

var fDiff = fEnd - fStart;

// convert to rounded minutes

fDiff = Math.round(fDiff / 60);

// get hours from fDiff

fHours = Math.floor(fDiff / 60);

// get minutes less than hour from fDiff

fMins = ((fDiff / 60) - fHours ) * 60;

// format fMins with leading zero

sMins = util.printf("%,302.0f", fMins);

// build display string

event.value = fHours + ':' + sMins;

}

Message was edited by: Kevin Lyons