Eliminate the Time from the Date for Pivot Table Use

  • Thread starter Thread starter dmarks1
  • Start date Start date
D

dmarks1

When I import date and time of day information from another program into
Excel the new cell includes both the date and time of day. I would like to
eliminate the time portion of the cell and only show the date. Reformatting
the cell only changes the view in the cell. The time of day is still
maintained in the background. I subsequently am using pivot tables and want
all days with the same date to be viewed as the same even though the time of
day for that date may vary. When the time is carried along with the date
the pivot table thinks each cell is different because the time of day is
diffierent.

Any ideas?

Soccer Referee
 
In the PivotTable, you could group the dates by day, or in the original
table, add a column in which you calculate the date from the date and
time column. For example, with the first date and time in cell A2, enter
the following formula in cell B2: =INT(A2)
and copy down to the last row of data.
Add this field to the pivot table.
 
Back
Top