Tuesday, May 27, 2014

yogi_Using Timestamp Column Compute Number Of Transactions For Each Day


                                         Google Spreadsheet   Post  #1651
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-27-2014
post by Thom Duncan: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/3wX7Mj5TRtw)
Ignore or delete time stamp in date fields
'd like to see a count of how many applications I receive each day, which I can do using a pivot table.
However, the value reported includes both the date and time, and I need to either delete the time stamp or ignore it.
Here's some sample data:
5/1/2013 1:52:00
5/1/2013 14:41:00
5/1/2013 21:57:00
5/2/2013 21:58:00
5/5/2013 13:07:00
5/6/2013 16:41:00
5/9/2013 18:50:00

I tried doing a search and replace for any values after 2013, which turned the time stamp to " 0:00:00", but I'd like to know if there's an easier solution that eliminates or ignores those values. Choosing to display just the date does not solve this issue.

Thanks!
----------------------------------------------------------------------------------------------