Excel workbookOfficial Zeyto

Staff Attendance, Overtime and Shift Planner (UAE)

An Excel workbook for owners, supervisors and HR officers in retail, hospitality, security, workshops and offices.

Know each person's hours and overtime at month end.

At a glance

  • FormatExcel workbook
  • DeliveryInstant download
  • In the box3 files, 688 KB
  • Works withMicrosoft Excel 2016 or later, or Google Sheets

How it works

  1. BuyPay on Stripe’s secure page.
  2. DownloadYour order page opens at once with a secure link.
  3. Open and useOpen the workbook in Excel and start from the example.

What you get

  • 9 sheets with about 13,600 formulas, 40 staff, 1,000 timesheet rows
  • Roster with cover and rest-day checks
  • Overtime in three buckets, counted only when approved
  • Late, short-hours and error checks on every row
  • Filled example for October 2026
Files and sizes (3)
  • staff-attendance-overtime-planner.xlsx341 KB
  • staff-attendance-overtime-planner-example.xlsx342 KB
  • README.txt4.0 KB

3 files, 688 KB in total. You download them from your order page after payment.

What it does not do

  • You type or paste clock times.
  • Every limit and rate shown is an example.
  • Confirm yours with MOHRE or a lawyer.

After you buy

  • Instant downloadYour order page opens right after payment with a secure link for each file. The link is emailed to you too.
  • A fresh link any timeLinks last 48 hours. Enter your order reference and the email you paid with and we will send a new one.
  • Help is one email awayWrite to support@zeyto.app with your order reference. The team answers every enquiry.
  • Fix, replace or refundIf a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Find my purchasesContact the Zeyto teamMarketplace terms

Full refund wording

Digital downloads (files, templates, skill packs, guides) are delivered straight away, so they are not refunded once downloaded. If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.

Applies to products sold by Zeyto itself. None of this takes away rights you have under UAE law.

About this product

Staff Attendance, Overtime and Shift Planner is an Excel workbook for UAE employers with shifts, long days or overtime that nobody can fully explain at month end.

Read the full description

Staff Attendance, Overtime and Shift Planner is an Excel workbook for UAE employers with shifts, long days or overtime that nobody can fully explain at month end. You plan the roster, enter what actually happened, and the workbook works out every person's hours and overtime by day type, then gives you the month's totals for payroll.

What is inside:

  • Nine sheets: Instructions, Settings, Shifts, Holidays, Employees, Roster, Timesheet (1,000 rows), Month Summary and Worked Example
  • Shift codes with start, end and unpaid break; shifts that cross midnight work, and an overnight shift is one row
  • A roster grid for up to 40 people and 31 days with codes for shifts, OFF, AL, SL, UL and PH; cover by shift for every day; red days where fewer people are on duty than you set; a flag when someone has fewer rest days than your minimum
  • A timesheet with the planned shift pulled from the roster, the day type (working day, rest day or public holiday), hours worked, normal hours, overtime, late minutes after your grace period, short hours and an error check on every row
  • Overtime split into the same three buckets as the WPS Payroll Workbook (normal day, night, rest day or holiday); only overtime marked as approved is counted for pay, and overtime awaiting approval is shown separately
  • A Ramadan switch for reduced daily hours, and an overtime cost estimate from the monthly pay and multipliers you set
  • A filled example for October 2026 with six fictional employees

Who it is for: owners, supervisors and HR officers in operations, retail, hospitality, security, workshops and offices where hours matter.

What it does not do: it is not a time clock and does not connect to a fingerprint, face or card device; you type or paste the clock times. Working hours, breaks, rest days, Ramadan hours, overtime rates, night hours and limits are set by law and your contract and differ by sector: every figure in the file (8 hours, 10 minutes grace, 1.25 and 1.5) is an example you replace after checking MOHRE, your PRO or a lawyer. Night hours are typed by you because the rule is yours to confirm. One calendar month per file.

Verified by recalculating the filled example with an independent engine and comparing every Month Summary figure with a separate calculation. Not opened in Microsoft Excel itself.

Requirements: Microsoft Excel 2016 or later, or Google Sheets.

Questions

Who is it for?
Owners, supervisors and HR officers in retail, hospitality, security, workshops and offices.
What do I need to use it?
Microsoft Excel 2016 or later, or Google Sheets.
How do I get it?
Pay on Stripe, then download from your order page at once. Links last 48 hours: ask for a fresh one with your order reference and email.
What if the file is wrong?
If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you. Read the terms.

Staff Attendance, Overtime and Shift Planner (UAE): AED 69

Pay once, download at once.

Damaged, will not open or not as listed? Tell us within 7 days and we fix it, replace it or refund you.

Questions before you buy? Contact the Zeyto team. This is sold by Zeyto (Emeron Infospace FZE) itself, not by an independent seller. See the marketplace terms.

Not sure it is the right one?

Works well with

Other official products that cover the same ground or finish the job.