Click Counter by Hour for Operator Call Log

**gpjcole** · 11-01-2010, 10:28 AM

Hello,
What I've been tasked with creating is a tallying call log for a operator's switchboard. Basically what I need to do is create two buttons (Inside Call & Outside Call) that work essentially as a click counter. I have that already built:

Please Login or Register  to view this content.

However I need to seperate this data by hour. My plan is to have a series of option buttons that designate each hour (8AM, 9AM, etc...) and the operator will tick the hour they're in, and when they press inside or outside the data will count in a table for that specific hour.

I hope that makes sense -- any help will be greatly appreciated.

Thanks

**royUK** · 11-01-2010, 10:29 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**Alf** · 11-01-2010, 11:24 AM

Hmmm, why not spend a bit more time on your project and write a macro
that records date and time as well as the tally?

Having gathered this raw data it can easily be converted into table form with
a total of “outside” and “inside” calls per hour and day.

**gpjcole** · 11-01-2010, 12:17 PM

Originally Posted by Alf

Hmmm, why not spend a bit more time on your project and write a macro
that records date and time as well as the tally?

Having gathered this raw data it can easily be converted into table form with
a total of “outside” and “inside” calls per hour and day.

Is that a fairly simple macro to write?

I'm decent in Excel, but VB is something I've only barely touched.

**Alf** · 11-01-2010, 02:07 PM

Well I think it's not to difficult. I've made a sample workbook. Have a look at it and see if this would suit you.

At the moment I've not done any sorting of data. Will do so later if and when you have a sutable workbook.

Alf

**gpjcole** · 11-01-2010, 02:45 PM

Originally Posted by Alf

Well I think it's not to difficult. I've made a sample workbook. Have a look at it and see if this would suit you.

At the moment I've not done any sorting of data. Will do so later if and when you have a sutable workbook.

Alf

That's almost exactly what I needed - I can probably figure out the filtering - but this is a huge help. Thanks a lot.

**Alf** · 11-01-2010, 03:22 PM

Glad to be of help. Will also have a go at the filtering but it's a bit difficult as Sweden uses a 24 hr clock and you uses the AM/PM notation.

So what works in Sweden may not work in the USA.

Have you considered how long you want to keep the data? A day, a week or a month. Perhaps you should add a button for clearing old indata?

Alf

**Alf** · 11-02-2010, 04:31 AM

Had problem filtering time data with "Autofilter" so I changed the macro to split the "now" fuction in a "Year-month-day" part and an "hour:min AM/PM" part. This solved my filtering problem.

Alf

**gpjcole** · 11-02-2010, 07:14 AM

Originally Posted by Alf

Glad to be of help. Will also have a go at the filtering but it's a bit difficult as Sweden uses a 24 hr clock and you uses the AM/PM notation.

So what works in Sweden may not work in the USA.

Have you considered how long you want to keep the data? A day, a week or a month. Perhaps you should add a button for clearing old indata?

Alf

Well we file a report once a month to our bosses - so the data will be collected for a month, compiled, and then sent off to the boss.

Thanks a lot

**Alf** · 11-02-2010, 01:29 PM

Home with a cold, bored so I added a report writing macro to the file.

The button for the report is on worksheet "Raw_data". Don't know if this is of any use to you, myself I enjoyed working a bit with excel as I had nothing else to do.

Alf

**gpjcole** · 11-04-2010, 09:57 AM

Originally Posted by Alf

Home with a cold, bored so I added a report writing macro to the file.

The button for the report is on worksheet "Raw_data". Don't know if this is of any use to you, myself I enjoyed working a bit with excel as I had nothing else to do.

Alf

That's awesome - I'm looking into your macro to set it up to separate the data not just by date, but by time - so we can see our peak hours (for scheduling - and to justify hiring more staff)

**Alf** · 11-04-2010, 11:59 AM

Glad you liked it. VBA is not that difficult and this is in my opinion the best forum to learn it.

If you are going to analyze the data in dept perhaps you should include weekdays as well just to see if there are "peak" days as well as "peak" hours.

Best of luck to you and feel free to PM if you think I can help in any way.

Alf

Click Counter by Hour for Operator Call Log

LinkBack

Thread Tools

Rate This Thread

Display

Click Counter by Hour for Operator Call Log

Re: Command Button / Check Box

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Re: Click Counter by Hour for Operator Call Log

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions