Help! I have a spreadsheet where I am applying a pivot table to find average costs per day. The problem is that my raw data shows the dates as 10/01/03 12:22:00 PM. Of course, when I create the table I get sometimes hundreds of lines for each day because it is separating the days by time of day. I just want to get rid of the time so I can run the pivot table to calcuate by each single date only.
I know that there are many of you out there who know exactly how to do this. Please share your knowledge with me - I'd really appreciate it!!
Thanks in advance,
krfb ;-)
Thanks!kb
I know that there are many of you out there who know exactly how to do this. Please share your knowledge with me - I'd really appreciate it!!
Thanks in advance,
krfb ;-)
Thanks!kb