Calculate difference between two time fields

Question

Hi all,I would appreciate it so much if you could help me out a little with this.I have a starttime and endtime fields but I would like the form to auto calculate for me once these two fields have been populated. Example:How do I make the form calculate “Duration” for me and the “Total” as well.How do I make the form let the user to move from column to column automatically? For example, after entering start time (HHMM), the cursor would automatically move to the End time column?Thank you and Regards,James

try67 · Accepted Answer

Change the field's Format to None and use this code for the calculation (this is for the A row):

var cStart = this.getField("Start1").value;
var cStop = this.getField("Stop1").value;
if (cStart != "" && cStop != "") {
    var tStart = parseTime(cStart);
    var tStop = parseTime(cStop);
    var total = (tStop - tStart)/(1000*60*60);
    var totalHours = Math.floor(total);
    var totalMinutes = (total-totalHours)*60;
    var totalHoursString = (totalHours<10) ? "0"+totalHours : ""+totalHours;
    var totalMinutesString = (totalMinutes<10) ? "0"+totalMinutes : ""+totalMinutes;
    event.value = totalHoursString + totalMinutesString;
}
else {
    event.value = "";
}