Employee Timesheet

Let staff punch in and out by project, then total approved hours and pay per person using their hourly rate.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Employees, Time entries

Fields

19

Views

grid, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Employees

6 fields · 3 sample rows

  • Totals (Grid)
EmployeeTextDepartmentSingle selectHourly rateCurrencyTime entriesLink to another tableTotal hoursRollupApproved payRollup
Zoya KhanEngineering₹1,20017 Nov 2026, 18 Nov 202612.25₹9,900
Ethan ClarkeMarketing₹95017 Nov 2026, 19 Nov 202610₹6,175
Lakshmi NarayanSupport₹60018 Nov 2026, 19 Nov 202613.50₹4,800
Field details
Employee · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Hourly rate · Currency
INR
Time entries · Link to another table
Links to Time entries
Total hours · Rollup
sum of Hours via Time entries
Approved pay · Rollup
sum of Approved amount via Time entries

Time entries

13 fields · 6 sample rows

  • Entries (Grid)
  • Awaiting approval (Grid)
  • Calendar (Calendar)
  • Log hours (Form)
  • Summary (Dashboard)
DateDateEmployeeLink to another tableProjectSingle selectClock inDurationClock outDurationBreak (min)NumberHoursFormulaRateLookupAmountFormulaBillableCheckboxApprovedCheckboxApproved amountFormulaWork doneLong text
17 Nov 2026Zoya KhanClient – Acme Retail9:3018:30458.25₹1,200₹9,900YesYes₹9,900Inventory sync API
17 Nov 2026Ethan ClarkeClient – Zenith Bank10:0017:00306.50₹950₹6,175YesYes₹6,175
18 Nov 2026Lakshmi NarayanAdmin8:0016:30308₹600₹4,800Yes₹4,800
18 Nov 2026Zoya KhanInternal tools9:1513:1504₹1,200₹4,800₹0
19 Nov 2026Ethan ClarkeClient – Acme Retail9:0012:45153.50₹950₹3,325Yes₹0
19 Nov 2026Lakshmi NarayanClient – Zenith Bank13:0019:00305.50₹600₹3,300Yes₹0
Field details
Date · Date
Employee · Link to another table
Links to Employees
Project · Single select
Client – Acme Retail, Client – Zenith Bank, Internal tools, Admin
Clock in · Duration
Clock out · Duration
Break (min) · Number
Hours · Formula
IF(AND({Clock in}, {Clock out}), ROUND(({Clock out} - {Clock in}) / 3600 - {Break (min)} / 60, 2), 0)
Rate · Lookup
Hourly rate via Employee
Amount · Formula
ROUND({Hours} * SUM({Rate}), 0)
Billable · Checkbox
Approved · Checkbox
Approved amount · Formula
IF({Approved}, {Amount}, 0)
Work done · Long text

Form view “Log your hours” asks for: Date, Employee, Project, Clock in, Clock out, Break (min), Billable, Work done.

Employee Timesheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates