Times in Pivot Tables

[seansr]

I have team data that I need to show a breakdown, so using a pivot table.
However, when I show the data it looks like it is only round what is left if the days (Part days and excluding the whole days)

if someone has done 75 hours doing something I need it to show 75:00

for example, I now that the all the entries add to 437 hours but only showing 05:02

any help would be much appreciated

Sean...

 

[Chihiro]

Go the Value field settings. Apply either [h]:mm or [hh]:mm format instead of h:mm.

h:mm can only show up to 23:59 then it rolls into next 24 hour period.

 

[seansr]

perfect, Thanks, works a treat