I don't have access to Access, or other database program. I think I will stick with Excel as my main data storage container, since that is what I know.

Now, I guess, it is time to learn something about Excel's pivot and database tools.

First question, then. After importing the data into the spreadsheet, what if anything do I need to do to make the source data more amenable to a pivot table? If I want to get an average for each calendar day, for example, do I need to add columns that separate out date and time from the time stamp?