# Calculating Time Utilisation

**URL:** <https://community.fibery.io/t/calculating-time-utilisation/3507>\
**Category:** Get Help\
**Created:** [November 9, 2022, 1:03pm UTC](https://community.fibery.io/t/calculating-time-utilisation/3507 "2022-11-09T13:03:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rawkode](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rawkode/32/5317_2.png) [@rawkode](https://community.fibery.io/u/rawkode)\
**Post date:** [November 9, 2022, 1:03pm UTC](https://community.fibery.io/t/calculating-time-utilisation/3507/1 "2022-11-09T13:03:23Z")

</div>

Hi,

One of my Fibery spaces is a CRM and I track Opportunities won. Each Opportunity has a “Duration” (Which is a DateTimeRange) and a “Committed” number of hours.

Example:

Client A - Oct 1st, 2022 → Dec 31st, 2022 - 45 hour commitment (retainer)  
Client B - Nov 1st, 2022 → Nov 2nd, 2022 → 16 hour commitment (on-site )

I can’t really find a way to calculate my saturation / utilisation for any given month or quarter.

Has anyone done this before?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 9, 2022, 2:48pm UTC](https://community.fibery.io/t/calculating-time-utilisation/3507/2 "2022-11-09T14:48:22Z")

</div>

What is your definition of ‘saturation/utilisation’? Is is calculated per week, per day, per month?  
What is your max availability? Do you include weekends/holidays?

I suspect you can do this using a report view, but need to know the answers to such questions first.

---

<div class="post-metadata">

**Author:** ![rawkode](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rawkode/32/5317_2.png) [@rawkode](https://community.fibery.io/u/rawkode)\
**Post date:** [November 9, 2022, 3:27pm UTC](https://community.fibery.io/t/calculating-time-utilisation/3507/3 "2022-11-09T15:27:37Z")

</div>

100% utilisation is 120 hours per month, or 15 days.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 9, 2022, 4:32pm UTC](https://community.fibery.io/t/calculating-time-utilisation/3507/4 "2022-11-09T16:32:51Z")

</div>

OK, so taking an example (slightly different to your above)

Client A - Sep 5th, 2022 → Nov 20th, 2022 → 45 hour commitment  
Client B - Oct 25th, 2022 → Nov 8th, 2022 → 16 hour commitment

What would be the answer to your utilisation for Sep, Oct and Nov?  
What would be the answer to your utilisation for Q3 and Q4?

(and if it’s not obvious, please explain how the calculation should work)?

---

<div class="post-metadata">

**Author:** ![rawkode](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rawkode/32/5317_2.png) [@rawkode](https://community.fibery.io/u/rawkode)\
**Post date:** [November 9, 2022, 4:50pm UTC](https://community.fibery.io/t/calculating-time-utilisation/3507/5 "2022-11-09T16:50:05Z")

</div>

I actually don’t know how to answer that and will accept any ideas you’ve seen work before 😃