Question about Microsoft Access 2000 (077-01277) for PC
Well, I work in a call center and we take call, we have to finish the calls at a specified time.Each calls could vary from 6 sec (Answering machine calls) to long calls. I need a timer to be created so that every time a call comes in and when the agent clicks on a start button the present time is displayed and when the call stops and the agent clicks on the stop button the present time is displayed on the excel sheet.
Create a button tied to a now function for each time, displayed based on your choices (probably in a second sheet, if you don't want the operator to see it).
Then, if you want this information stored for future reference, it will take writing/recording a macro to write the data to a line, move down one line, and record at the next time the button(s) are clicked. The reason I say button(s) is that you could have the macro record both times based on hitting the end button, or you could have a beginning record when button #1 is hit, and then a second macro moves to a second cell when button #2 is hit and both record the time (now). Then you have a third cell which calculates the time involved by subtracting beginning time from end time.
If you need further assistance, please post back. Otherwise, thanks for rating FixYa!
Posted on May 05, 2008
Hi, I was looking to create a timmer. with stop and start option on excel.I have found the anser withyahoo group answers, that was help full and free, i got the VB macro programee. if you still can help me , here is the query,
I need a timer with stop and start option,
when i click on the star button i want the present time coming up on a cell(any cell) and when i click on the stop, i need to get the presen tme on the other cell, i need to clculate the time spent between the 2times.
i also need the time geting accumalated in the different sheet to calculate, how many times i have clicked and the difference.
Thank you for you any help you provide.
Posted on Apr 04, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Feb 05, 2012 | Sony VAIO VGN-N325E Notebook
Jan 31, 2012 | GE Spacemaker 1.7 Cu. Ft. Over-the-Range...
Jun 10, 2011 | RTO Zilla 24/7 Digital Timer Power Center
Jan 18, 2011 | Intermatic Programmable 24 Wall Switch...
Sep 08, 2010 | Coralife Zilla Aqualight Power Center
Feb 22, 2010 | Coralife Zilla Aqualight Power Center
Dec 18, 2008 | Microsoft Excel for PC
Oct 29, 2008 | Microsoft Excel for PC
Dec 12, 2007 | Microsoft Excel for PC
Feb 18, 2018 | Adobe Computers & Internet
75 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: