Displaying seconds as HH:MM:SS in a pivot table

[Justin_Iagulli2]

Is there a way to sum time in a pivot table and have it appear in the HH:MM:SS format? My columns are user, start time, end time and I'd like to group by user and show the total time worked.

Thanks in advance.

[#2]

Hi Justin,

Unfortunately, the pivot charts do not offer the ability to change the format of the values used to apply the time format you are looking for. If you are calculating the amount of time an individual spent working on an item in Workflow you might want to try using the Workflow Activity data provider. This data provider will offer the ability to adjust the unit of measurement used for the “time in queue” calculation. By using the “time in queue” feature you’ll then be able to have the total time worked on an item calculated automatically so that you can create custom calculations to display your data in other meaningful ways.

If you have any other questions, please feel free to contact your first line of support.

Thanks for using Community!

-Dante D.