Employee Schedule Template

Plan shifts by person, role and location, with paid hours per shift and a weekly total checked against each person’s cap.

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

Staff, Shifts

Fields

18

Views

grid, calendar, kanban, 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.

Staff

8 fields · 4 sample rows

  • Staff (Grid)
NameTextRoleSingle selectPhonePhoneMax hours / weekNumberShiftsLink to another tableShift countCountScheduled hoursRollupOver capFormula
Riya DesaiSupervisor+91 98111 223344519 Nov 2026, 20 Nov 2026216
Carlos MendezBarista+34 612 345 6783019 Nov 2026, 21 Nov 2026212.25
Amit JoshiCashier+91 98111 998874019 Nov 2026, 21 Nov 2026215
Hannah BrooksKitchen+1 415 555 01342020 Nov 202615.67
Field details
Name · Text
Role · Single select
Supervisor, Cashier, Barista, Kitchen, Cleaner
Phone · Phone
Max hours / week · Number
Shifts · Link to another table
Links to Shifts
Shift count · Count
Scheduled hours · Rollup
sum of Paid hours via Shifts
Over cap · Formula
IF(AND({Max hours / week}, {Scheduled hours} > {Max hours / week}), 'Over by ' & ROUND({Scheduled hours} - {Max hours / week}, 1) & ' h', '')

Shifts

10 fields · 7 sample rows

  • Rota (Grid)
  • Calendar (Calendar)
  • By shift (Kanban)
  • Hours (Dashboard)
DateDateEmployeeLink to another tableShiftSingle selectStartDurationEndDurationBreak (min)NumberPaid hoursFormulaLocationSingle selectStatusSingle selectNotesLong text
19 Nov 2026Riya DesaiMorning7:0015:30308Koramangala outletConfirmed
19 Nov 2026Carlos MendezMorning6:3012:30155.75Airport kioskConfirmed
19 Nov 2026Amit JoshiAfternoon12:0020:00307.50Koramangala outletScheduled
20 Nov 2026Hannah BrooksNight22:004:00205.67Central kitchenSwap requestedLooking for someone to cover
20 Nov 2026Riya DesaiAfternoon13:0021:30308Koramangala outletScheduled
21 Nov 2026Carlos MendezEvening16:0023:00306.50Airport kioskScheduled
21 Nov 2026Amit JoshiMorning8:0016:00307.50Koramangala outletCalled in sick
Field details
Date · Date
Employee · Link to another table
Links to Staff
Shift · Single select
Morning, Afternoon, Evening, Night
Start · Duration
End · Duration
Break (min) · Number
Paid hours · Formula
IF(AND({Start}, {End}), ROUND((IF({End} < {Start}, {End} + 86400, {End}) - {Start}) / 3600 - {Break (min)} / 60, 2), 0)
Location · Single select
Koramangala outlet, Airport kiosk, Central kitchen
Status · Single select
Scheduled, Confirmed, Swap requested, Called in sick
Notes · Long text

Employee Schedule Template: 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