Exclude weekends from "Time between" calculated properties

What is it?

You can now exclude weekends when using Time between calculated properties. This option allows you to calculate the time between two dates while skipping weekends, defined as 12:00am Saturday through 11:59pm Sunday, based on your account’s time zone. This update is available when creating or editing a Time between calculation property.

Why does it matter?

For many teams, weekends aren’t working time—but until now, Time between properties counted them anyway. This made it harder to accurately measure things like response times, resolution times, or internal SLAs.

By excluding weekends, you can:

• - Better reflect actual working time in your calculations
• - Get more accurate reporting for operational and service metrics
• - Reduce the need for workarounds or manual adjustments

This is especially helpful for teams that want clearer insights into how long work actually takes during business days.

How does it work?

When creating or editing a Time between calculated property, you’ll see a new option to exclude weekends.

• - Select Calculation as the field type
• - Choose Time between as the calculated property type
• - Pick your start and end date properties
• - Check the option to exclude weekends

Once enabled, weekends (Saturday and Sunday) are automatically excluded from the calculation, using your account’s time zone.

Exclusions:

This initial release focuses on excluding weekends only. It does not currently support:

• - Excluding holidays
• - Excluding custom or admin-defined days
• - User-specific time zones
• - Excluding weekends for Time since or Time until calculations

We’re starting with this beta to gather feedback and better understand how teams want to use this capability before expanding it further.

Who gets it?

Commerce Hub Professional, Commerce Hub Enterprise, Content Hub Professional, Content Hub Enterprise, Marketing Hub Professional, Marketing Hub Enterprise, Data Hub Professional, Data Hub Enterprise, Sales Hub Professional, Sales Hub Enterprise, Service Hub Professional, Service Hub Enterprise, Smart CRM Professional, Smart CRM Enterprise