Pivot table with times

[SandsB]

My data file has a rows with EmployeeName, Function, Time. Each employee might have one to 5 rows, 1 for each of the 5 functions. I was to make a report that has a row as a header with the Function and then in rows you'd see the EmployeeName and in the columns to the right see the Time the employee spent in each function.

Seems to me I could do this as a Pivot Table. But Time when I put Time in the values area (bottom right) it shows up as just a number 1 because it's the count and each employee only has 1 row of data for each function. OK, fine - I'll change the field setting to Sum. Since there's only 1 value the sum will be the same as the time value. Nope - it displays a 0. Same for Max and Min.

The format of the raw data shows the column with the Time as General. I tried changing that - it laughed at me.

This has got to be possible - just don't see what stupid thing I'm doing wrong.

 

[SpillerBD]

The Time "value" you have is apparently a text string, hence the laughing.
You probably need to utilize the function TIMEVALUE....