3 Replies Latest reply on Dec 3, 2018 2:47 PM by Don Wise

# Convert Hours to Minutes with seperate measures

I have couple of measures called 'Duration Hrs' and 'Duration Min' which shows the time for a certain event. For example, if it takes 3 hours and 10 mins, it will show 3 in 'Duration Hrs' and 10 in 'Duration Min'. I have couple of questions with regards to this:

1. How do you convert the number of hours in measure 'Duration Hrs' to minutes?

2. If possible to convert to mins, how do you combine both measures together?

• ###### 1. Re: Convert Hours to Minutes with seperate measures

Hello Sanil,

Time calculations are tricky to deal with depending on the data.  For example, some calculations work very well so long as they're under 24 hours (within the same 24 hour period), while those data greater than 24 hours (i.e., several days) might require something entirely different.  Can you supply sample data or workbook please? Thx, Don

• ###### 2. Re: Convert Hours to Minutes with seperate measures

Thanks for getting back, I have attached a sample excel sheet of what I am talking about.

• ###### 3. Re: Convert Hours to Minutes with seperate measures

Hi Sanil,

Attached is a 2018.3 workbook.  Converting Hours to Minutes is: ([Duration Hrs])*60

Then to add the Measures, use the previous calculation name (I called it Hours to Minutes) + Duration Minutes to get total minutes:

In this screenshot and workbook I converted each to a Dimension to show the results; you'd keep yours as Measures to do other calculations.  Thx, Don