Calculating Regular Hours and Overtime Hours

Forum|Forum|3 years ago
October 3, 2022
2 replies
4678 views

I am creating a timesheet that requires taking the total amount of hours worked and slitting them up between regular hours worked and overtime hours worked.

Three columns:

(TotalHours) The first column I have the total amount of hours worked in the week. The caluation to add up the hours worked each day is easy and works.

(RegHours) The second colum would be the total of regular hours worked, which would equal 40 hours or less.

(OTHours) The thrid column would be the total hours worked over 40 hours.

Hour would I write the code for the Regular and Overtime hour calculations?

Subcontractor_Labor_Records_(fillable_w_calculations)_Updated_9-15-22.pdf

How to

This topic has been closed for replies.

Correct answer Nesa Nurani

For regular hours use this:
var h1 = Number(this.getField("TotalHours1").value);
if(h1 > 40)event.value = 40;
else
event.value = h1;

For overtime hours use this:
var h2 = Number(this.getField("TotalHours1").value);
var h = 0;
if(h2 > 40)h = h2-40;
if(h2 > 40)
event.value = h;
else
event.value = "";

Nesa Nurani

Correct answer

Community Expert

For regular hours use this:
var h1 = Number(this.getField("TotalHours1").value);
if(h1 > 40)event.value = 40;
else
event.value = h1;

For overtime hours use this:
var h2 = Number(this.getField("TotalHours1").value);
var h = 0;
if(h2 > 40)h = h2-40;
if(h2 > 40)
event.value = h;
else
event.value = "";