Skip to content
Hypamoon

For teams that run on Sesame HR

Sesame HR annual hours report per person

Sesame has reports for clocked time, for absences and for the hours balance. To see in one place how the worked hours and the paid and unpaid absences of a person add up over a year, teams often combine reports in a spreadsheet.

How it goes today

  1. Download the clock-in report for the year.
  2. Download the absence report for the same period.
  3. Put both in a spreadsheet and match the rows per person.
  4. Add the paid absences to the worked hours with formulas.

How it can go

Worked hours and absence hours per person, added up per month and for the year.

On the first working day of each month HR gets a report with one row per person: hours clocked, hours of paid absence by type, hours of unpaid absence and holiday hours, for last month and for the year so far, with the hours to work from Sesame next to it. You can filter it by department and open it as a spreadsheet.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Sesame HR key in the portal, never in the chat.

Your request

With Hypamoon, on the first working day of each month, make a report from Sesame HR with one row per employee: hours clocked, hours of paid absence by type, hours of unpaid absence and holiday hours, for last month and for the year so far, with the hours to work from Sesame next to it. Let me filter by department and download it as a spreadsheet.

An administrator switches on the API in Sesame under Applications, Plans and pricing (it comes with the top plan, otherwise as an add-on), then creates a token under Settings, Integrations, API and notes the data region shown on that page. It stays yours.