Hello!
I am a "generally knowledgeable" user with Excel, but cannot figure how to do this one. Would appreciate any advice.
My boss wants to know how many phone calls came in to the company between 4:00 PM and 5:00 PM, for the last six months.
Our phone system software keeps logs and can create reports in Excel. I can set it to create a report by date range and beginning and end with time. For example: I can pick today's date and ask for a report of calls from 4-5PM. However, if I want to pick a date range of suppose 7 days, I cannot get a report of each day within a specific hour range. It just picks all calls that came in over that week period. If I pick Monday-Friday for the date range, and a time range of 4 PM to 5 PM, it will pick all calls between Monday at 4 PM until Friday at 5 PM.
So now I have a spreadsheet that shows all calls that came in over a six month period. There is a column labeled "Call Time", and it has info in it like this: "8/2/15 9:02:42 AM". There are associated columns with data such as call destination, call length, etc.
My question is this: how can I find the entries in the "Call Time" column, that are only between 4:00:00 PM - 5:00:00 PM? And include the associated lines for these entries?
I have been looking at the FIND feature, but not sure how to search the "Call Time" column because it also includes the dates.
Any advice is truly appreciated!
Bookmarks