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
Thanks for getting back, I have attached a sample excel sheet of what I am talking about.
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