Forum Discussion

Ganapathi's avatar
Ganapathi
Frequent Visitor
10 years ago

Equivalent for excel time format 37:30:55

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

 

Need Help

1 Reply

  • Twan's avatar
    Twan
    Icon for Advocate IV rankAdvocate IV
    10 years ago

    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.