Forum Discussion
Sum Times
Hi all, I successfully used a calculated column using DAX to sum times that were formatted in excel to a custom format [h]:mm:ss. The formula that was used : Formatted =
VAR _DaysInHours = IN...
Your variable that uses FORMAT and your return are text type so can't be summed. I would use a similar approach to sum everything in minutes and then divide by 60 to get total hours in decimal form.
Regards,
Pat