# I want to display total working hours Per month in report

**URL:** <https://community.eazybi.com/t/i-want-to-display-total-working-hours-per-month-in-report/11329>\
**Category:** Questions & Answers\
**Tags:** jira, calculatedmembers\
**Created:** [December 21, 2022, 6:47am UTC](https://community.eazybi.com/t/i-want-to-display-total-working-hours-per-month-in-report/11329 "2022-12-21T06:47:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Umar](https://community.eazybi.com/letter_avatar_proxy/v4/letter/u/59ef9b/32.png) [@Umar](https://community.eazybi.com/u/Umar)\
**Post date:** [December 21, 2022, 6:47am UTC](https://community.eazybi.com/t/i-want-to-display-total-working-hours-per-month-in-report/11329/1 "2022-12-21T06:47:26Z")

</div>

Hi, I am new to eazybi. I want to create a report where i have the sum of a custom field data in number for example at the end of the month the sum custom field number is 80.and the total working hours per month is let’s suppose 90. so, i can compare both numbers. But my question is from where I can get the total number of working hours in a month for example 1 working day have 8 hours and in month there is 25 working day, I should be 25\*8. so, I can compare this number with the number enter in custom field.

---

<div class="post-metadata">

**Author:** ![VasileS](https://community.eazybi.com/user_avatar/community.eazybi.com/vasiles/32/4882_2.png) [@VasileS](https://community.eazybi.com/u/VasileS)\
**Post date:** [December 21, 2022, 10:06am UTC](https://community.eazybi.com/t/i-want-to-display-total-working-hours-per-month-in-report/11329/2 "2022-12-21T10:06:10Z")

</div>

Hello @Umar !

See this: [Find total working days in a month](https://community.eazybi.com/t/find-total-working-days-in-a-month/1239)  
You may want to use DateDiffWorkdays() instead of DateDiffDays…

Let me know if it helps! 🙂  
Kind regards,  
Vasile S.

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [December 30, 2022, 2:53pm UTC](https://community.eazybi.com/t/i-want-to-display-total-working-hours-per-month-in-report/11329/3 "2022-12-30T14:53:55Z")

</div>

Hi @Umar !

Thanks @VasileS for the suggestion!

You can even go a step further and use the relatively new [DateDiffWorkhours()](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datediffworkhours) function.

Use the Month level from the Time dimension in the Rows section of your report. Then [define a new calculated measure](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Howtodefineanewcalculatedmember) in the Measures dimensions with a formula like this:

```mdx
DateDiffWorkhours(
  [Time].CurrentHierarchyMember.StartDate,
  [Time].CurrentHierarchyMember.NextStartDate, '67','9-18'
)

```

​Let me know if this fits your use case or if you have any additional questions on this!

​Best regards,  
​Nauris / eazyBI support