pivot table not reading date formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a pivot table report to sum a worksheet that has times recorded
in it. The data is formatted like this

Start Finish
Total Time
6/14/2006 12:00:00 AM 6/14/2006 1:40:00 AM
1:40

I want the pivot table to sum by month.

I can't figure out how to get this done. I put a column beside the data to
pull the date from the start times for the table. But I can't find a format
or formula that the pivot table will read the month from (other than retyping
the dates).

Help?


Thanks.
 
If you want to pivot table to sum by months, you'll need to have a helper
column with the month (and possibly year)

Try:

=date(year(A1),month(A1),1) to get the first day of the month.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Peculiar default cell format 1
Using VBA to create charts 1
grouping dates in a pivot table 1
Help on Pivot Table 2
Pivot Table Summary Error? 6
Pivot Table sorts date as Alpha, not as Date 6
rolling 12 month date filter for pivot table? 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Back
Top