Easily Track Work Hours Online

Date	From	To	Break Deduction

Copy first row's data down

Clear all

Round Time:      

No Round Round to the nearest 5 minutes Round to the nearest 10 minutes Round to the nearest 15 minutes Round to the nearest 30 minutes Round to the nearest hour

Report Header:

Report Notes:

Include payment information

Base Pay Rate: per hour

Overtime Pay:

No overtime rate, pay base rate for overtime worked

No overtime pay, pay max hours per day

No overtime pay, pay max hours per week

Overtime pay after hours per day

Overtime pay after hours per week

Overtime Rate: times base rate

Show blank days in report

Save values to this browser

Clear Calculate

`); // Close the document and trigger print printWindow.document.close(); printWindow.focus(); printWindow.print(); printWindow.close(); // Show the buttons back after printing actionButtons.style.display = 'block'; }); } function timeToMinutes(time) { var period = time.slice(-2); // Extract AM/PM var timeStr = time.slice(0, -2); // Get the time part (without AM/PM) if (period !== 'AM' && period !== 'PM') { timeStr = time; // Keep the time as it is (24-hour format) } let [hours, minutes] = timeStr.split(':').map(num => parseInt(num, 10)); // Convert to 24-hour format if (period === 'PM' && hours !== 12) { hours += 12; } if (period === 'AM' && hours === 12) { hours = 0; } // Return the total minutes since midnight return hours * 60 + minutes; } function breakTimeToMinutes(breakTimeStr) { breakTimeStr = breakTimeStr.toString().trim(); // Check if the input contains a colon if (breakTimeStr.includes(':')) { const [hours, minutes] = breakTimeStr.split(':').map(num => parseInt(num, 10)); // Check if hours and minutes are valid numbers if (isNaN(hours) || isNaN(minutes)) { throw new Error("Invalid time format."); } return (hours * 60) + minutes; // Convert to total minutes } else { // If no colon is present const minutes = parseInt(breakTimeStr, 10); // Check if the hours is a valid number if (isNaN(minutes)) { throw new Error("Invalid number of hours."); } return minutes; // Convert hours to minutes } } $('#calculator').on('click',function() { var jsonData = []; var totalData=[]; var total_overtime=0; var total_overtime1=0; var total_base_value=0; var total_over_time_value=0; var over_all_total=0; var total_base_amount=0; var total_over_time_amount=0; var row_total=0; var total_time=0; var over_all_time=0; var blankdays=0; var customamount=0; var max_hours_per_day=0; var max_hours_per_week=0; var over_pay_per_day=0; var over_pay_per_week=0; var total_round_off=0; var storelocal= $('#savedata').is(':checked'); var showblankdays=$('#showblankdays').is(':checked'); if(!showblankdays){ blankdays=1; } customamount=$('#amount_per_hour').val(); max_hours_per_day=$('#get8time').val(); max_hours_per_week=$('#get40time').val(); over_pay_per_day=$('#over8time').val(); over_pay_per_week=$('#over40time').val(); for (let i = 1; i <= 7; i++) { var day = document.querySelector(`input[name="label${i}"]`)?.value || ""; var fromTime = document.querySelector(`input[name="from1${i}"]`)?.value || ""; var toTime = document.querySelector(`input[name="to1${i}"]`)?.value || ""; var breakTime = document.querySelector(`input[name="rate1${i}"]`)?.value || ""; var breakTime_date=""; if(breakTime===""){ breakTime="0:00"; breakTime_date = breakTimeToMinutes(breakTime); }else{ breakTime_date = breakTimeToMinutes(breakTime); } var startMinutes = timeToMinutes(fromTime); var endMinutes = timeToMinutes(toTime); // Calculate the difference in minutes var differenceInMinutes = Math.abs(endMinutes - startMinutes); differenceInMinutes -= breakTime_date; var hours=0; var minutes=0; var hours1=0; var minutes1=0; if(fromTime!="" && (startMinutes!=endMinutes)) { // Convert the difference from minutes to hours hours = Math.floor(differenceInMinutes / 60); minutes = differenceInMinutes % 60; hours1=Math.floor(differenceInMinutes / 60);; minutes1=differenceInMinutes % 60; } var timeChange; // Check if the value is a string if (typeof accumulatedData.time_change === "string") { // Parse it to a number timeChange = parseFloat(accumulatedData.time_change); // Ensure it's a valid number if (isNaN(timeChange)) { console.error("Invalid number format for time_change."); timeChange = 0; // Or handle this case as needed } } else { // Assume the value is already a number timeChange = accumulatedData.time_change; } var roundedHours=0; if(timeChange!="0" || timeChange!=0) { switch (timeChange) { case 5: case 10: case 15: case 30: // Calculate the remainder let remainder = minutes % timeChange; // Round down if the remainder is less than half the interval, otherwise round up if (remainder < timeChange / 2) { minutes -= remainder; // Round down } else { minutes += (timeChange - remainder); // Round up } // Adjust hours if minutes exceed 59 if (minutes === 60) { minutes = 0; hours = (hours + 1) % 24; // Increment hour and wrap around if it exceeds 23 } roundedHours=hours+'h '+minutes+'m'; break; case 60: // Round to the nearest hour if (minutes < 30) { minutes = 0; // Round down to the hour } else { minutes = 0; // Reset minutes hours = (hours + 1) % 24; // Increment hour } roundedHours=hours+'h '+minutes+'m'; break; default: console.error("Invalid interval. Use 5, 10, 15, 30, or 60."); break; } } else { roundedHours=0; } var basePay=0; var value=0; var over_time=0; var total_overtime_hour=0; var total_overtime_minute=0; var total_overtime_hour1=0; var total_overtime_minute1=0; var total_base=40; var total_row=0; var total_row1=0; var total_row2=0; var total_minutes=0; var total_hours=0; if(accumulatedData.pay==="") { basePay=0; total_base_value=0; total_round_off=0; total_hours=total_hours+hours1; total_minutes=total_minutes+minutes1; total_time=total_time+total_hours+(total_minutes/60); if(`${i}`==7) { hours=Math.floor(total_time); minutes=Math.round((total_time % 1) * 60); if(timeChange!="0" || timeChange!=0) { switch (timeChange) { case 5: case 10: case 15: case 30: // Calculate the remainder let remainder = minutes % timeChange; // Round down if the remainder is less than half the interval, otherwise round up if (remainder < timeChange / 2) { minutes -= remainder; // Round down } else { minutes += (timeChange - remainder); // Round up } // Adjust hours if minutes exceed 59 if (minutes === 60) { minutes = 0; hours = (hours + 1) % 24; // Increment hour and wrap around if it exceeds 23 } total_round_off=hours+'h '+minutes+'m'; break; case 60: // Round to the nearest hour if (minutes < 30) { minutes = 0; // Round down to the hour } else { minutes = 0; // Reset minutes hours = (hours + 1) % 24; // Increment hour } total_round_off=hours+'h '+minutes+'m'; break; default: console.error("Invalid interval. Use 5, 10, 15, 30, or 60."); break; } } else { total_round_off=0; } } } else if(accumulatedData.pay===accumulatedData.get_non_over_time){ if(fromTime!=0 && (startMinutes!=endMinutes)) { var time_taken=hours+(minutes/60) if(minutes!="0"||minutes!=0) { value=time_taken*accumulatedData.amount_per_hour; value = Math.round(value * 1000) / 1000; total_row=total_row+value; total_base_value=total_base_value+total_row; basePay=Math.floor(time_taken)+'h '+ Math.round((time_taken % 1) * 60)+ 'm x $'+accumulatedData.amount_per_hour+" = $"+value; } else { value=hours*accumulatedData.amount_per_hour; value = Math.round(value * 1000) / 1000; total_row=total_row+value; total_base_value=total_base_value+total_row; basePay=hours+'h x $'+accumulatedData.amount_per_hour+" = $"+value; } // calculating the total time total_hours=total_hours+hours1; total_minutes=total_minutes+minutes1; total_time=total_time+total_hours+(total_minutes/60); if(`${i}`==7) { hours=Math.floor(total_time); minutes=Math.round((total_time % 1) * 60); if(timeChange!="0" || timeChange!=0) { total_round_off=0; switch (timeChange) { case 5: case 10: case 15: case 30: // Calculate the remainder let remainder = minutes % timeChange; // Round down if the remainder is less than half the interval, otherwise round up if (remainder < timeChange / 2) { minutes -= remainder; // Round down } else { minutes += (timeChange - remainder); // Round up } // Adjust hours if minutes exceed 59 if (minutes === 60) { minutes = 0; hours = hours + 1; // Increment hour and wrap around if it exceeds 23 } total_round_off=hours+'h '+minutes+'m'; break; case 60: // Round to the nearest hour if (minutes < 30) { minutes=0; } else { minutes=0; hours = hours + 1; } minutes = 0; // Reset minutes to 0 total_round_off = hours + 'h ' + minutes + 'm'; break; default: console.error("Invalid interval. Use 5, 10, 15, 30, or 60."); break; } } else { total_round_off=0; } } } }else if(accumulatedData.pay===accumulatedData.get_non_over_day){ if(fromTime!=0 && (startMinutes!=endMinutes)) { // calculating the round off if(hours=accumulatedData.pay_get_day) { var extra_hours=hours-accumulatedData.pay_get_day; var extra_minutes=minutes; if(extra_minutes!="0" || extra_minutes!=0) { extra_minute = extra_minutes / 60; if(extra_hours!=0) { extra_hour = extra_hours + extra_minute; value=extra_hour*accumulatedData.amount_per_hour*accumulatedData.overtime_ration; value = Math.round(value * 1000) / 1000; over_time=extra_hours+'h '+extra_minutes+'m x $'+accumulatedData.amount_per_hour+' x '+accumulatedData.overtime_ration+" = $"+value; total_row2=total_row2+value; total_row=total_row+value+value_base; } else { value=(extra_minutes/60)*accumulatedData.amount_per_hour*accumulatedData.overtime_ration; value = Math.round(value * 1000) / 1000; over_time=extra_minutes+'m x $'+accumulatedData.amount_per_hour+' x '+accumulatedData.overtime_ration+" = $"+value; total_row=total_row+value+value_base; total_row2=total_row2+value; } } else{ value=extra_hours*accumulatedData.amount_per_hour*accumulatedData.overtime_ration; value = Math.round(value * 1000) / 1000; over_time=extra_hours+'h x $'+accumulatedData.amount_per_hour+' x '+accumulatedData.overtime_ration+" = $"+value; total_row=total_row+value+value_base; total_row2=total_row2+value; } } else { over_time=0; total_row=total_row1; } total_over_time_value=total_over_time_value+total_row2; if(`${i}`==7) { hours=Math.floor(total_time); minutes=Math.round((total_time % 1) * 60); if(timeChange!="0" || timeChange!=0) { switch (timeChange) { case 5: case 10: case 15: case 30: // Calculate the remainder let remainder = minutes % timeChange; // Round down if the remainder is less than half the interval, otherwise round up if (remainder < timeChange / 2) { minutes -= remainder; // Round down } else { minutes += (timeChange - remainder); // Round up } // Adjust hours if minutes exceed 59 if (minutes === 60) { minutes = 0; hours = hours + 1; // Increment hour and wrap around if it exceeds 23 } total_round_off=hours+'h '+minutes+'m'; break; case 60: // Round to the nearest hour if (minutes < 30) { minutes=0; } else { minutes=0; hours = hours + 1; } minutes = 0; // Reset minutes to 0 total_round_off = hours + 'h ' + minutes + 'm'; break; default: console.error("Invalid interval. Use 5, 10, 15, 30, or 60."); break; } } else { total_round_off=0; } } } }else if(accumulatedData.pay===accumulatedData.get_over_week) { total_overtime_hour=total_overtime_hour+hours1; total_overtime_minute=total_overtime_minute+minutes1; total_overtime=total_overtime+total_overtime_hour+(total_overtime_minute/60); total_time=total_overtime; if(`${i}`==7) { var over_time_hours=0; var over_time_minutes=0; over_time_hours = Math.floor(total_time); over_time_minutes = Math.round((total_time % 1) * 60); if(timeChange!="0" || timeChange!=0) { switch (timeChange) { case 5: case 10: case 15: case 30: // Calculate the remainder var remainder1 = over_time_minutes % timeChange; // Round down if the remainder is less than half the interval, otherwise round up if (remainder1 < timeChange / 2) { over_time_minutes -= remainder1; // Round down } else { over_time_minutes += (timeChange - remainder1); // Round up } // Adjust hours if minutes exceed 59 if (over_time_minutes === 60) { over_time_minutes = 0; over_time_hours = over_time_hours + 1; // Increment hour and wrap around if it exceeds 23 } total_round_off=over_time_hours+'h '+over_time_minutes+'m'; break; case 60: // Round to the nearest hour if (over_time_minutes < 30) { over_time_minutes = 0; // Round down to the hour } else { over_time_minutes = 0; // Reset minutes over_time_hours = over_time_hours + 1; // Increment hour } total_round_off=over_time_hours+'h '+over_time_minutes+'m'; break; default: console.error("Invalid interval. Use 5, 10, 15, 30, or 60."); break; } } else { total_round_off=0; } if(over_time_hours>accumulatedData.pay_get_week) { var over_extra_hours=over_time_hours-accumulatedData.pay_get_week; var over_extra_time=0; if(over_time_minutes==0) { over_extra_time=over_extra_hours; } else { over_extra_time=over_extra_hours+(over_time_minutes/60); } var value_basepay=accumulatedData.pay_get_week*accumulatedData.amount_per_hour; value_basepay = Math.round(value_basepay * 1000) / 1000; basePay=accumulatedData.pay_get_week+'h x $'+accumulatedData.amount_per_hour+' = $'+value_basepay; total_base_value=total_base_value+value_basepay; var value_over_time=over_extra_time*accumulatedData.amount_per_hour*accumulatedData.overtime_ration; value_over_time = Math.round(value_over_time * 1000) / 1000; over_time=over_extra_hours+'h '+ over_time_minutes+'m'+' x $'+accumulatedData.amount_per_hour+' x '+accumulatedData.overtime_ration+" = $"+value_over_time; total_over_time_value=total_over_time_value+value_over_time; } else { var over_extra_time=over_time_hours+(over_time_minutes/60); var value_basepay=over_extra_time*accumulatedData.amount_per_hour; value_basepay = Math.round(value_basepay * 1000) / 1000; basePay=over_time_hours+'h '+ over_time_minutes+'m'+ ' x $'+accumulatedData.amount_per_hour+' = $'+value_basepay; total_base_value=total_base_value+value_basepay; } } } else { basePay=0; total_base_value=0; } if(`${i}`==7) { total_base_amount=total_base_value; total_over_time_amount=total_over_time_value; var over_all_time_hours = Math.floor(total_time); // This will give you the integer part // Extract the remaining minutes (after the decimal part) var over_all_time_minutes = Math.round((total_time % 1) * 60); over_all_time=over_all_time_hours+'h '+over_all_time_minutes+'m '; if(total_over_time_amount) { over_all_total=total_base_amount+total_over_time_amount; over_all_total = Math.round(over_all_total * 1000) / 1000; over_all_total="$"+over_all_total; } else { over_all_total=total_base_amount; over_all_total = Math.round(over_all_total * 1000) / 1000; over_all_total="$"+over_all_total; } if(accumulatedData.pay===accumulatedData.get_non_over_week) { total_base_amount=basePay; } else if(accumulatedData.pay===accumulatedData.get_over_week) { total_base_amount=basePay; total_over_time_amount=over_time; } else if(accumulatedData.pay===accumulatedData.get_over_day) { total_over_time_amount="$"+Math.round(total_over_time_amount*1000)/1000; total_base_amount="$"+Math.round(total_base_amount*1000)/1000; } else { total_base_amount='$'+ Math.round(total_base_amount*1000)/1000; } } if (day) { jsonData.push({ day: day, fromTime: document.querySelector(`input[name="from1${i}"]`)?.value || "", toTime: toTime, breakTime: breakTime_date, hours: hours1+"h "+ minutes1+"m", roundedHours:roundedHours, basePay:basePay, over_time:over_time, total_row:total_row, header:accumulatedData.report_header, footer:accumulatedData.report_note, pay_method:accumulatedData.pay, blank:accumulatedData.blank_days, get_non_over_time:accumulatedData.get_non_over_time, get_non_over_day:accumulatedData.get_non_over_day, get_non_over_week:accumulatedData.get_non_over_week, get_over_time_day:accumulatedData.get_over_day, get_over_week:accumulatedData.get_over_week, round:accumulatedData.time_change, blank_days:blankdays, payoption:accumulatedData.payoption, selectnearestvalue:accumulatedData.selectnearestvalue, custom_amount:customamount, max_hours_per_day:max_hours_per_day, max_hours_per_week:max_hours_per_week, over_pay_per_day:over_pay_per_day, over_pay_per_week:over_pay_per_week, store_break_time:breakTime, }); } } var storelocal= $('#savedata').is(':checked'); if (storelocal) { // Convert jsonData to a JSON string before storing localStorage.setItem("jsonarray", JSON.stringify(jsonData)); } totalData.push({ pay_method:accumulatedData.pay, total_base_amount:total_base_amount, total_over_time_amount:total_over_time_amount, over_all_total:over_all_total, over_all_time:over_all_time, header:accumulatedData.report_header, footer:accumulatedData.report_note, blank_days:blankdays, get_non_over_time:accumulatedData.get_non_over_time, get_non_over_day:accumulatedData.get_non_over_day, get_non_over_week:accumulatedData.get_non_over_week, get_over_time_day:accumulatedData.get_over_day, get_over_week:accumulatedData.get_over_week, roundedHours:total_round_off, }); appendDynamicContent(jsonData,totalData); }); });