cancel
Showing results for
Did you mean:
See all
See all
##### Groups
Explore all groups

# Calculation of incorrect hours and minutes in eazyBi

I need to create a custom field by calculating estimated hours, hours remaining and hours spent in a report, but setting ## h ## m, the hour and minute values end up repeating as in the image below:

How can I resolve for my report to bring estimated hours, hours remaining and hours spent according to the filter used?

Hi,

The formatting you have selected (## h ## m) requires that value is converted to minutes in order to display results in hours and minutes.

I believe you could create new calculated members in "Measures" dimension and then you can multiply hour-related measures with 60 the to get result in minutes.

Kind regards,

Martins / eazyBI support

Hello @Mārtiņš Vanags ,

Greetings!

Is it possible to convert those converted values to number of days (#h #m to number of days)?

Eg: if converted value is 72h, then number of days should be 9 (Considering that the number of hours per day = 8 hours)

Regards,

Pooja

Hi @Pooja Singh ,

For days you could use the same approach @Mārtiņš Vanags suggested - multiplying the hours by 60 and select the 'Days Hours Minutes' formatting.

To display it in the workday fashion - 1 day = 8 hours, try to create a calculated measure with the formula below:

`(Case When [Measures].[Hours spent]>8Then Format(Int([Measures].[Hours spent]/8),"0d ")Else ""End)||(Case When [Measures].[Hours spent]>=1Then Format([Measures].[Hours spent] - Int([Measures].[Hours spent]/8) * 8,"0h ")Else ""End)||(Case When [Measures].[Hours spent]>0Then Format((([Measures].[Hours spent] -Int([Measures].[Hours spent]/8) * 8) -Int([Measures].[Hours spent] -Int([Measures].[Hours spent]/8) * 8))*60,"00m")Else ""End)`

Kind regards,

Roberts / eazyBI support

1 person likes this

Community showcase
Published Mar 13, 2019 in Marketplace Apps

### Marketplace Spotlight: Marketing apps for Confluence to keep your teams working on the same page

&nbsp...

251 views 0 6

### Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Connect with like-minded Atlassian users at free events near you!

##### Find my local user group

Unfortunately there are no AUG chapters near you at the moment.