Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summarize times in a pivot table
I have 3 columns.......date , name, and total time in 0:00 time format. I want to use a pivot table to give me total time by date and name. It appears pivot table will only summarize cells in number format. I am new to pivot tables so please be gentle :) -- Mark@Marc ------------------------------------------------------------------------ Mark@Marc's Profile: http://www.excelforum.com/member.php...o&userid=28126 View this thread: http://www.excelforum.com/showthread...hreadid=476377 |
#2
|
|||
|
|||
Summarize times in a pivot table
If the times entered are truly numeric, it should be simple to get their
totals. (To check if the times are numbers rather than strings, you could try to format them using the 'comma' or 'percent' styles; if they don't change when you did that, you've got strings; if they do change, then just 'undo' and we can move forward). If you've constructed the pivot table to show 'sum of time' as the data field, you probably get back strange decimal numbers as results. You just need to format these. Right-click on one of the result cells, and select 'field settings.' Click on Number... From the Category list, choose Custom, then select (or type) h:mm. Click OK a few times a you should be set. (If the times you have are strings, created a new helper column and use the timevalue function to convert the strings to times; you'll again probably see odd decimal numers, which you can correct by applying that same custom h:mm format. Note that dates and times in Excel are just numbers with special formats applied.) "Mark@Marc" wrote: I have 3 columns.......date , name, and total time in 0:00 time format. I want to use a pivot table to give me total time by date and name. It appears pivot table will only summarize cells in number format. I am new to pivot tables so please be gentle :) -- Mark@Marc ------------------------------------------------------------------------ Mark@Marc's Profile: http://www.excelforum.com/member.php...o&userid=28126 View this thread: http://www.excelforum.com/showthread...hreadid=476377 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table for 3 columns of elapsed times | Excel Discussion (Misc queries) | |||
Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |