Question about Microsoft Access 2000 (077-01277) for PC

2 Answers

I need to Have a timer created in excel

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.

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

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

  • Cheryl Whalen May 05, 2008

    Wanted to add one more comment - NOW will reset to current each time it is used, so I would recomment that in your macro, you copy the cell to another and paste as a value. This way, yiur calculation is based on the original data and does not change and always become -0-. Thanks again!

×

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

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.

Regards

Rochboy

Posted on Apr 04, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to make vaio recovery disc for


Follow these steps to create your recovery discs.

From within the VAIO
Recovery Center application, under Choose a program, click Create Recovery Discs.

NOTE: The VAIO Recovery Center can be accessed from within Windows Help and Support. Click Backup & Recovery, then click Launch VAIO Recovery Center.

Next to Create Recovery Discs window, click the Start button.

In the When recovery discs are needed window, click the Next button.

In the Choose your media window, click the Next button.

NOTE: Although an option is provided for creating Dual Layer (DL) discs, that option will not produce usable discs on this model. Ensure the Create recovery disc(s) using... DVD(s) option remains selected before clicking Next.

Insert a blank, recordable DVD into the DVD drive.
In the Insert a blank disc window, click the OK button.

Insert a new disc when necessary as instructed.
When all the disks have been created, click the Finish button.

NOTE: After the recovery discs have been created the first time, any disc can be created again by selecting the disc from the list and clicking Next.

Feb 05, 2012 | Sony VAIO VGN-N325E Notebook

1 Answer

Microwave lights up doesn't turn on


The part of the oven called the "magnetron" (this part is what creates/generates the microwave energy that heats the food or liquid) is burned out, the cost to repair is more this part is more than the cost to replace with the cost of Microwaves so depressed by the stagnant economy.

Jan 31, 2012 | GE Spacemaker 1.7 Cu. Ft. Over-the-Range...

1 Answer

I have the timer set, all 7 cycles to come on at 6am go off at 6pm. set and checked. put mode on auto but light did not come on. it only came on when set on the on mode. please help, thank you


You are having problem programming zilla digital power strip timer.
http://waterheatertimer.org/GE-timers-and-manuals.html#zilla

Either timer is defective, or programming has conflicts that cause timer to ignore programming, or blue-yellow outlets are not understood, or combination of these problems.

Zilla yellow outlets are for daytime hours.
Blue outlets for nighttime.
The instruction manual does NOT specify what hours are for daytime. 6 am to 6 pm? Or 12 am to 12pm?
The zilla analog timer divides day and night at 12 and 12.

If digital timer is also 12 and 12, then you cannot set ON at 5:59am and OFF at 5:59pm without fudging the current time setting. For example offset current time by exactly 6 hours.

Add a comment for more free help

Upvote the help.
And take advantage of fixya expert assistance live.
For a price, expert works with you while you work on timer or any do-it-yourself project.
Fixya is always less expensive than a service call.

Jun 10, 2011 | RTO Zilla 24/7 Digital Timer Power Center

1 Answer

I have and Intermatic EJ351C wall timer. I had one and dead after 3~4 years. This is one burn the light bulbs almost every months for 3 times in a row. Can you tell me what is wrong


1) Electronic devices don't work as expected and have short lifespan when circuit is not clean.
Buy cheap circuit analyzer at home center and test outlet on same circuit breaker.
Contact local electrician to fix any problem.

2) Intermatic has excellent customer service:
http://www.intermatic.com/customer%20service.aspx

3) I test timers. 4-6% arrive defective. Return timer for exchange.

Add a comment for more free help.
Also take advantage of fixya phone service.
For a price, expert speaks with you over phone while you work on timer or any do-it-yourself project.
Fixya is always less expensive than a service call.

Jan 18, 2011 | Intermatic Programmable 24 Wall Switch...

1 Answer

With the power center, do the yellow (daytime circuits only work from 12am to 11:59pm, even if the program setting is from say 7 am to 3pm?? and when you set the "time cycles" which number corresponds to...


Yellow outlets are controlled for 12 hours (approx).
Your schedule is 8 hours.
To solve problem: The timer does not know what time it is until you set current time. So set current time so your 8 hour schedule falls within the 'daytime' hours.
http://waterheatertimer.org/GE-timers-and-manuals.html#zilla

Absolutely feel obligated to upvote the help.
Or take advantage of fixya expert assistance live.
For a price, expert works with you while you work on timer or any do-it-yourself project.
Fixya is always less expensive than a service call.

Sep 08, 2010 | Coralife Zilla Aqualight Power Center

1 Answer

How to set timer for aqualight digital power center.. it has 7 time cycles per day but do i need to set all 7 cycle and if now i do i set it..


With digital Zilla timer, you can set from 1 to 7 programs.
You can set one program, and that's it, or set 2 programs or 3.
Up to 7.
Open following link to identify timer and download manual.
http://waterheatertimer.org/GE-timers-and-manuals.html#zilla

Absolutely feel obligated to upvote the help.
Or take advantage of fixya expert assistance live.
For a price, expert works with you while you work on timer or any do-it-yourself project.
Fixya is always less expensive than a service call.

Feb 22, 2010 | Coralife Zilla Aqualight Power Center

1 Answer

Increment a number per record in Microsoft Excel


For what you are talking about doing, Microsoft Access would probably be a better option. With Microsoft Access, you can create a custom form and have it automatically give a number.

More information about Access:
http://www.bcschools.net/staff/AccessHelp.htm

Dec 18, 2008 | Microsoft Excel for PC

3 Answers

Microsoft Excel Temp Files


I just finished with Trend Micro help support and they solved this problem for me. Open the main console for Trend Micro. Click on Viruses & Spyware Controls. Click on the "settings" for Protection Against Viruses & Spyware. Click on Advanced Settings. Under the section for "What Should TMIS Check for Threats" click on the circle for "Specify Targets that you choose". Click on "Select" next to "Ignore Specific Files & Folders". Then Add and folders of files that you do not want Trend Micro to check and make backups for. That solved my issue...hope it helps you too.

Oct 29, 2008 | Microsoft Excel for PC

3 Answers

Excel


Your issue is not stated very clearly so I'll make some guesses about your problem.
I'm guessing you mean "rate" (Starts-per-Week) is the number of starts you have that week.
I'll guess that those starts are not new start dates but something else-maybe job starts.
Each start implies a job duration period. Do you want to know the finish date of each job or are you only interested in when the last job will be completed? Don't think I can give you meaningful Excel formulas at this time.
Maybe Excel is the best tool for this job but I suspect someting like Microsoft Project would be more appropriate (but expensive). You should Google "project tracking", "project orgainization" and "Gant chart" and read what you find to get a good feel for your problem and how to solve it.

Dec 12, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Access 2000 (077-01277) for PC Logo

73 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...