Jump to content

Hello, I have a list in Google sheets that contains 1000 or so phone records that came to our office. I need to find how many calls came in each day and in what hour and put each value in the appropriate cell (so one cell would show how many calls came on Tuesday at 3pm). I have very little experience with sheets or Excel and know nothing about it's syntax and functions. Any help?

 

The date and time are in the same cell for each call and are formatted as MONTH/DAY/YEAR HOUR:MINUTE. If you need more info I'll be happy to give it.

Link to comment
https://linustechtips.com/topic/814120-google-sheets-help/
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×