Forum Discussion
littlepatos
Helper II
Helper IICalculate Time Data into Hours & Minutes using SUM
I am trying to show SUM of total hours for each activity Hours & Minutes column can't be set as TIME so unsure how to show visual with aggregate SUM TimeHours & MinutesMinutesMinjutes as V...
Yes. Multiply the duration by 24, that will give you the hours with fractions.
Depends on how you get the original duration. Remember that you cannot create columns from measures.
littlepatosHelper II
Helper IIWould it be possible to show as decimals? Eg: 6 and a half hours is 6.5
lbendlin
Super User
Super UserYes. Multiply the duration by 24, that will give you the hours with fractions.
- littlepatos
lbendlin Thanks - I feel I am close but not quite.
Do I do this by adding a new column with 24 then create a Measure to multiply by Duration by the New Column?
- lbendlin
Depends on how you get the original duration. Remember that you cannot create columns from measures.
- littlepatos
Thanks lbendlin this worked 🙂