Student Timesheet

Student employees clock in and out of campus jobs, supervisors approve shifts, and hours and pay roll up per student.

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

Education

Tables

Student workers, Shifts

Fields

20

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.

Student workers

9 fields · 4 sample rows

  • Workers (Grid)
StudentTextStudent IDTextDepartmentSingle selectPositionTextHourly rateCurrencyWeekly hour capNumberShiftsLink to another tableApproved hoursRollupGross payFormula
Priyanka DasU2391047LibraryCirculation desk assistant$15.502016 Nov 2026, 17 Nov 20267.75$120
Tyler BrooksU2388120IT Help DeskTech support associate$17.001517 Nov 2026, 19 Nov 20264$68
Mariana LopezU2402211Dining ServicesCafé barista$15.002018 Nov 20260$0
Kwame OwusuU2379934Recreation CenterFront desk attendant$15.251218 Nov 20263.67$56
Field details
Student · Text
Student ID · Text
Department · Single select
Library, IT Help Desk, Dining Services, Admissions, Recreation Center
Position · Text
Hourly rate · Currency
USD
Weekly hour cap · Number
Shifts · Link to another table
Links to Shifts
Approved hours · Rollup
sum of Approved hours via Shifts
Gross pay · Formula
ROUND({Approved hours} * {Hourly rate}, 2)

Shifts

11 fields · 6 sample rows

  • Timesheet (Grid)
  • Calendar (Calendar)
  • Log a shift (Form)
  • Hours (Dashboard)
DateDateStudentLink to another tableClock inDateClock outDateBreak (min)NumberHoursFormulaTask / dutyTextApprovedCheckboxApproved hoursFormulaSupervisorTextNotesText
16 Nov 2026Priyanka Das16 Nov 202616 Nov 2026153.75Circulation deskYes3.75Linda Park
17 Nov 2026Priyanka Das17 Nov 202617 Nov 2026304Shelving returnsYes4Linda Park
17 Nov 2026Tyler Brooks17 Nov 202617 Nov 202604Help desk ticketsYes4Raj Malhotra
18 Nov 2026Mariana Lopez18 Nov 202618 Nov 2026154Morning café shift0Denise Harper
18 Nov 2026Kwame Owusu18 Nov 202618 Nov 2026203.67Front desk & equipment checkoutYes3.67Coach Allen
19 Nov 2026Tyler Brooks19 Nov 2026Laptop imaging0Raj MalhotraStill on shift
Field details
Date · Date
Student · Link to another table
Links to Student workers
Clock in · Date
Clock out · Date
Break (min) · Number
Hours · Formula
IF(AND({Clock in}, {Clock out}), ROUND((DATETIME_DIFF({Clock out}, {Clock in}, 'minutes') - {Break (min)}) / 60, 2), BLANK())
Task / duty · Text
Approved · Checkbox
Approved hours · Formula
IF(AND({Approved}, {Hours}), {Hours}, 0)
Supervisor · Text
Notes · Text

Form view “Log your shift” asks for: Date, Student, Clock in, Clock out, Break (min), Task / duty, Supervisor, Notes.

Student 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