Skip to main content
Participant
July 23, 2026
Question

I need to a PDF form to calculate the number of hours between two times, subtracting breaks.

  • July 23, 2026
  • 1 reply
  • 11 views

I haven’t been able to find an answer that helps.

    1 reply

    Participant
    July 23, 2026

    I’ve been searching for days and haven’t been able to find a script that at least calculates the time worked with breaks subtracted. Here’s what I was trying to do with scripts copied from the forums, noting that I have information here that’s not needed…

    if ((this.getField("FinishTimeWEDNESDAY").value.length == 0) || (this.getField("StartTimeWEDNESDAY").value.length == 0)) {

    event.value = " 0 Hours 0 Minutes";

    }

    else{

    var timefinished = this.getField("FinishTimeWEDNESDAY").value;

    var timestarted = this.getField("StartTimeWEDNESDAY").value;

    var datetimefinished = new Date('1970/01/01' + " " + timefinished);

    var datetimestarted = new Date('1970/01/01' + " " + timestarted);

    if(datetimefinished<datetimestarted)
    {
    var date=new Date(datetimefinished)
    date.setDate(date.getDate()+1);
    datetimefinished=date;
    }

    var difflnMilliSeconds = Math.abs(datetimefinished - datetimestarted)/1000;

    var hours = Math.floor(difflnMilliSeconds / 3600) % 24;

    difflnMilliSeconds -= hours *3600;

    var minutes = Math.floor(difflnMilliSeconds / 60) % 60;

    difflnMilliSeconds -= minutes * 60;

    event.value = hours + (minutes/60) ;

    event.value = getField("TotalHoursMONDAY").value - getField("Lunch BreakWEDNESDAY").value - getField("Other BreaksWEDNESDAY").value;
    }