Here is the script I am using:
function Time2Num(sTime, cFormat) {
// convert a date time string to seconds since the epoch date
var oTime = util.scand(cFormat, sTime); // date time object
var fTime = oTime.valueOf(); // time string to milliseconds
return Math.round(fTime / 1000); // return rounded seconds
}
function TimeDiff(sEnd, sStart) {
// compute difference in time within same day as minutes
var fEnd = 0; // default value if not data
var fStart = 0; // default value if not data
var cDateFormat = "m/d/yyyy "; // date format string
var sNowDate = util.printd(cDateFormat, new Date()); // get today's date as "m/d/yyyy'
var cDateTimeFormat = cDateFormat + "h:MM tt";
// compute difference if we have data
if(sEnd != "" & sStart != "") {
// get end time in minutes
var cDateTimeValue = sNowDate + sEnd; // start date time string
var fEnd = Time2Num(cDateTimeValue, cDateTimeFormat) / 60; // convert to seconds and divide by 60 sec
// get start time in minutes
var cDateTimeValue = sNowDate + sStart; // start date time string
var fStart = Time2Num(cDateTimeValue, cDateTimeFormat) / 60; // convert to seconds and divide by 60 sec
} // end if we have value
return fEnd - fStart; // compute and return the difference in minutes
} // end function
function Mins2HrsMins(fMinutes) {
// convert seconds into formatted string of hours:minutes
var cDisplayFormat = "%01.0f" + ":" + "%02.0f"; // format for returned value
var fHrs = Math.floor(fminutes / 60); // compute whole hours from the difference
var fMins = fMinutes % 60; // get minutes less than 1 hour form the difference
return util.printf(cDisplayFormat, fHrs, fMins); // format and return computed value
} // end function
var fDiff = TimeDiff(this.getField("Field2_Time").value, this.getField("Field1_Time").value)
event.value = Mins2HrsMins(fDiff); // format computed value
All the above code is in the "Calculate>Custom Calculate Script" of the "TotHours" field.
I have the Javascript Debugger enabled in Acrobat and when I enter the time in "Field2_Time" and hit the tab key I get this in the Debugger:
fminutes is not defined
31:Field:CalculateException in line 31 of function Mins2HrsMins, script Field:Calculate
Exception in line 37 of function top_level, script Field:Calculate
ReferenceError: fminutes is not defined
31:Field:Calculate
I hope this helps.
Thank you so much!
