• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Times in Pivot Tables

S

seansr

Member
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...
 

Attachments

  • Toggl_time_entries April.xlsx
    40.5 KB · Views: 1
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.
 
You must log in or register to reply here.
Back
Top