Another timesheet calculation

Question

firstly, i do not knkow coding at all.i am trying to make a fillable timesheet for my employees. i need the job total section to auto populate, i would like it so my guys didnt have to enter times in 24-hr format.  and even better if they didnt have to use ":" when entering times.  *Sorry they are whiny babies!i am having trouble with a section for job total which should just be end time - start timeminutes need to be calculated as a percentage of an houri had this in excel but other people were not so excel friendly so im just trying to convert my excel form into a fillable pdfin excel i simple had this formula in the column=(a2-a1)*24any help would be appreciated! just lemme know what other info you may need to resolve this

steven34895068sco8 · Accepted Answer

If you want to calculate in 12h format (H:MM tt) 2:00 pm, 8:00 am...etc use this script (it will calculate all 12 rows and total):

var total = 0;
for (var i=1; i<=12; i++) {
var startField = "START TIMERow" + i;
var endField = "END TIMERow" + i;
var totalField = "TOTAL HOURSRow" + i;
var t1 = this.getField(startField).valueAsString;
var t2 = this.getField(endField).valueAsString;

if (t1 !== "" && t2 !== "") {
var d1 = util.scand("mm/dd/yyyy H:MM tt", "01/01/2024 " + t1);
var d2 = util.scand("mm/dd/yyyy H:MM tt", "01/01/2024 " + t2);

var diffInMinutes = Math.round((d2.getTime() - d1.getTime()) / 60000);
var totalTime = (diffInMinutes / 60).toFixed(2);
this.getField(totalField).value = totalTime;
total += parseFloat(totalTime);} 
else {
this.getField(totalField).value = "";}}

event.value = total.toFixed(2);

Here is your file with script added:

https://drive.google.com/file/d/1MtWj8c7v8uvP2C41voCtBKt9BvRy2U3R/view?usp=sharing

@try67 and @Nesa Nurani, thank you both so much for your time and patience with me on this issue. it works great.

try67 · Answer

You can use exactly the same formula in the Simple Field Notation section of the Calculate tab of the Properties dialog of a text field in Acrobat, just drop the equals sign (and of course adjust the field names, as needed).

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded