---
title: "HubSpot business days: time without weekends · Hypamoon"
description: "Working out HubSpot ticket and deal times in business days in Excel? Get the time per ticket and per stage in working days, without weekends and holidays."
url: https://hypamoon.com/connect-to/hubspot/business-days
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [HubSpot](https://hypamoon.com/connect-to/hubspot)
3.  Business days

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=hubspot/business-days)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~hubspot/business-days&say=ticket%20and%20deal%20stage%20times%20in%20HubSpot%20counted%20in%20working%20days%2C%20without%20weekends%20and%20public%20holidays%2C%20saved%20on%20the%20ticket%20with%20a%20monthly%20overview.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=hubspot/business-days)

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

-   [**I merge duplicate contacts one by one.**](https://hypamoon.com/connect-to/hubspot/duplicates)
-   [**I clear old tasks by hand after a deal or ticket closes.**](https://hypamoon.com/connect-to/hubspot/task-cleanup)
-   [**I clone won deals by hand to set up the renewal.**](https://hypamoon.com/connect-to/hubspot/renewals)
-   [**I change our workflows every time someone goes on holiday.**](https://hypamoon.com/connect-to/hubspot/out-of-office)
-   [**I compare last week's deal export with this week's to see what changed.**](https://hypamoon.com/connect-to/hubspot/deal-changes)
-   [**I add the contacts of a company to each new deal by hand.**](https://hypamoon.com/connect-to/hubspot/deal-contacts)
-   [**I export our HubSpot reports to send to people without a login.**](https://hypamoon.com/connect-to/hubspot/shared-report)
-   [**I take our own test entries off the form counts every month.**](https://hypamoon.com/connect-to/hubspot/form-leads)
-   [**I move contacts to another company one by one.**](https://hypamoon.com/connect-to/hubspot/move-contacts)
-   [**I calculate our stage conversion rates by hand.**](https://hypamoon.com/connect-to/hubspot/stage-conversion)
-   [**I copy notes and calls out of HubSpot record by record.**](https://hypamoon.com/connect-to/hubspot/activity-export)
-   [**I move open tasks by hand when records change owner.**](https://hypamoon.com/connect-to/hubspot/task-handover)
-   [**I check by hand which won deals have no products.**](https://hypamoon.com/connect-to/hubspot/deals-without-products)
-   [**I clean up names, countries and company fields in HubSpot every week.**](https://hypamoon.com/connect-to/hubspot/data-cleanup)
-   [**I go through the pipeline by hand to find deals that went quiet.**](https://hypamoon.com/connect-to/hubspot/stale-deals)
-   [**I calculate commission from HubSpot exports in a spreadsheet.**](https://hypamoon.com/connect-to/hubspot/commissions)
-   [**I export each object from HubSpot by hand to keep a copy.**](https://hypamoon.com/connect-to/hubspot/backup)
-   [**I add the country code to phone numbers by hand.**](https://hypamoon.com/connect-to/hubspot/phone-format)
-   [**I set the subscription by hand for people who already confirmed.**](https://hypamoon.com/connect-to/hubspot/consent-sync)
-   [**I track the time zones of my contacts in a spreadsheet.**](https://hypamoon.com/connect-to/hubspot/local-time)
-   [**I write the formal greeting by hand for each contact.**](https://hypamoon.com/connect-to/hubspot/salutation)
-   [**I split full names into first and last name in a spreadsheet.**](https://hypamoon.com/connect-to/hubspot/name-split)
-   [**I cannot show what a form said when someone signed up.**](https://hypamoon.com/connect-to/hubspot/consent-records)
-   [**I type our exchange rates into HubSpot by hand.**](https://hypamoon.com/connect-to/hubspot/exchange-rates)
-   [**I rename product lines by hand on quotes in other languages.**](https://hypamoon.com/connect-to/hubspot/quote-translation)
-   [**I check customer VAT numbers by hand on the VIES site.**](https://hypamoon.com/connect-to/hubspot/vat-check)
-   [**I add the VAT rate by hand to each line.**](https://hypamoon.com/connect-to/hubspot/vat-rates)
-   [**I rebuild HubSpot invoices elsewhere to send an e-invoice.**](https://hypamoon.com/connect-to/hubspot/xrechnung)
-   [**I make our invoices again elsewhere to get a Factur-X file.**](https://hypamoon.com/connect-to/hubspot/factur-x)
-   [**I link branch records to their parent company one by one.**](https://hypamoon.com/connect-to/hubspot/parent-companies)
-   [**I look up each customer's prices and change the deal lines by hand.**](https://hypamoon.com/connect-to/hubspot/customer-prices)
-   [**I keep the reseller and end user in text fields on each deal.**](https://hypamoon.com/connect-to/hubspot/partner-deals)
-   [**I build our Gift Aid claim in a spreadsheet from HubSpot exports.**](https://hypamoon.com/connect-to/hubspot/gift-aid)
-   [**I export HubSpot to a spreadsheet every week.**](https://hypamoon.com/connect-to/hubspot/spreadsheet-sync)
-   [**I copy deal details into our contract template by hand.**](https://hypamoon.com/connect-to/hubspot/deal-documents)
-   [**I tick off event attendees by hand from a list.**](https://hypamoon.com/connect-to/hubspot/event-attendance)
-   [**I keep a branch per postcode in our workflow to route leads.**](https://hypamoon.com/connect-to/hubspot/territories)
-   [**I number our deals by hand from a counter in a spreadsheet.**](https://hypamoon.com/connect-to/hubspot/record-numbers)
-   [**I work out renewal and follow-up dates by hand.**](https://hypamoon.com/connect-to/hubspot/date-calculations)
-   [**I keep prepaid hours in a spreadsheet next to our tickets.**](https://hypamoon.com/connect-to/hubspot/prepaid-hours)
-   [**I print the notification email to keep a copy of each form.**](https://hypamoon.com/connect-to/hubspot/form-pdf)
-   [**I copy NPS scores from another survey tool into HubSpot.**](https://hypamoon.com/connect-to/hubspot/nps-survey)
-   [**I work out deal margins in a spreadsheet.**](https://hypamoon.com/connect-to/hubspot/deal-margin)
-   [**Everything for HubSpot**](https://hypamoon.com/connect-to/hubspot)
