Skip to content
Hypamoon

For teams that run on HubSpot

HubSpot business days: time without weekends

When your promise to customers is in working days, the time a ticket took is often worked out in a spreadsheet, with the weekends and public holidays taken off by hand.

How it goes today

  1. Export the tickets with the create date and the close date.
  2. Use a working days formula in Excel.
  3. Keep a separate list of public holidays and take them off.
  4. Copy the result into the monthly report.

How it can go

Ticket and stage times counted in working days, without weekends and public holidays.

For each closed ticket, the time from opening to closing is counted in working days, using your working week and the public holidays of your country. The result is written to a field on the ticket in HubSpot, so you can report on it there, and each month you get an overview per pipeline and per owner. The same works for the days a deal spent in each stage.

Say this in ChatGPT, Claude or Copilot

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

Your request

With Hypamoon, for every ticket in our HubSpot that is closed, count the working days from opening to closing, without weekends and the public holidays of our country, and write it to a field on the ticket. Email me a monthly overview per pipeline and owner, and do the same for days spent per deal stage.

A super admin creates the HubSpot service key under Development, Keys, and picks what it may read and change. It stays yours.

More for teams on HubSpot