Date/Time issue with Pivot Table

L

Lori

Hello.

I have column of data that is both date and time. However when I create the
pivot table I only want it to summarize the date.

I've formatted both the source and the pivot table to display on the date
but formatting doesn't affect the underlying data so if a date has three
different times, then the pivot table has three different entries for a given
date.

I can (and have) parsed out the serial number to remove the time portion but
that gets a bit time consuming and this comes up frequently in different
spreadsheets. I'm wondering if there's away to do it automatically, if
there's a function I'm missing?

Lori
 
L

Lori

Dear Ed,

When I right click on the date/time field in the pivot table I get the
option for group, but does this process mean I have go through and manually
group all the dates but it will only group selections.

Or am I supposed to create the groups in the main spreadsheet because I have
a variety of date/time columns...

Lori
 

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

Pivot Table date format 1
Issue with pivot table 1
date filter in a pivot table 1
Pivot Table Update 3
pivot table counting 1
formatting date for pivot table 2
Pivot table subtotals 2
Pivot Table - Changes 5

Top