Equivalent for excel time format 37:30:55

[Ganapathi]

Hi All,

I want to add number of time values with [HH:MM:SS] format , e.g. total hours worked by an employee in the week like below

[Twan]

I couldn't figure out a way to do it while maintaining the time formatting.  Each time the sum of the time went past 24 it would change the time back to 0.  So a total time of 26:00:00 would be formatted as 2:00:00.

I was able to get it working though if you don't mind changing the format from Time to Decimal.  You can do this by adding a new calculated column that converts the time value to a decimal value in hours.  The calculated column would look something like this and have its Data Type set to Decimal Number:

Time as Decimal = TIMEVALUE(Table[Time]) * 24

Now that Time is stored as a decimal it can be summed correctly in tables and other visualizations.