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;