Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Eliminate the Serial Number for time from Date?
I have a long spread sheet that has two columns of dates (Received and
Finished) that I am importing into a pivot table and would like to use the dates in my pivot, less the time. For daily use, I do use the time with the date, but only want the date for use in the pivot table. How can I eliminate the time serial number, before importing into my pivot, apart from editing each individual cell? Have a \\\I/// Blessed Day, ( o o ) --oOO-(_)-OOo-- Bob Gotti |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Eliminate the Serial Number for time from Date?
Dates are stored as whole numbers (days elapsed since the reference
date), whereas times are stored as fractions of a 24 hour day. So, you can get the date part by =INT(A1) if A1 holds your date/time combination. Format as required, then the formula can be copied down. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Eliminate the Serial Number for time from Date?
After you create the pivottable, you can rightclick on the date/time field and
choose Group and show detail. Then Group, then by Days. Bob Gotti wrote: I have a long spread sheet that has two columns of dates (Received and Finished) that I am importing into a pivot table and would like to use the dates in my pivot, less the time. For daily use, I do use the time with the date, but only want the date for use in the pivot table. How can I eliminate the time serial number, before importing into my pivot, apart from editing each individual cell? Have a \\\I/// Blessed Day, ( o o ) --oOO-(_)-OOo-- Bob Gotti -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
cells changing from number to date | Excel Discussion (Misc queries) | |||
How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) |