Is there any function to convert decimal to Minutes/Hours

Questions & Answers
, ,
1

Is there any function to convert decimal to Minutes/Hours obtained using DateDiffMinutes?

2

Hi @Srivatsa,

For each eazyBI calculated measure, you may specify the formatting. And you can choose to show duration in ##h ##m . When using this format, make sure the result is calculated in minutes.

  • In your case, function DateDiffMinutes() returns the duration already in minutes and the formatting ##h ##m will work as expected without any further transformations.

  • If the result is in days, you may convert days to minutes is by multiplying duration in days with 24 (hours in a day) and 60 (minutes in an hour) like this: [Measures].[Total resolution days] * 24 * 60
    And now you can apply the formating to shows duration in ##h ##m.

More details on formatting are here: Calculated measures and members - eazyBI for Jira

Best,
Zane / support@eazybi.com