Hello, I don't do javascript here and while I tried searching.....I am not sure if any of the results I landed on pertain to me. Here are the fields I have.
Start Time
End Time
Total Time (In minutes)
The start/end times are military time format. Just need the Total Time filed calculated and displayed in minutes.
Assuming the values in Start Time and End Time follow this format: 15:31, enter this custom calculation script in the Total Time field:
var startHour=this.getField("Start Time").value.split(":")[0];
var startMin=this.getField("Start Time").value.split(":")[1];
var endHour=this.getField("End Time").value.split(":")[0];
var endMin=this.getField("End Time").value.split(":")[1];
event.value=Number(60*(endHour-startHour)) + Number(endMin-startMin);
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices