ATTENDANCE &
PAYROLL ENTRY

Daily timesheet — support.madrasmedia.net

—

Today's Entries

—

Total Records

⚙ Setup Required: Deploy the Google Apps Script below and paste its URL as SCRIPT_URL in this file. Then share your sheet with the script's service account. See the <script> block at the bottom of this file for full instructions.

01 — Date & Time

Date *

Time Check-In *

Time Check-Out

02 — Employee Details

Employee Name *

Employee ID *

Designation *

03 — Shift Duration

Total Shift Hours *

⏱Enter shift hours above

04 — Job Cards & Hours Worked

05 — Hours Summary

⏱ Live Calculation

—

Shift Hours

Set above

—

Working Hours

Sum of job cards

—

Idle Hours

Shift − Working

⚠ Job card hours exceed the shift duration — please review.

06 — Location

Location *

ATTENDANCE &PAYROLL ENTRY

ATTENDANCE &
PAYROLL ENTRY