How to Make a Count-Down Timer in Excel?

**e4excel** · 11-19-2009, 03:38 AM

How to Make a Count-Down Timer in Excel?

Dear Forum,

I am preparing a Small Test for the Human Resource Department which can help them in the Screening process.

This test would be a Multi-option questionnaire and would be Time-Bound and the questions would be picked from a Bin of Questions with each question already assigned with the number of minutes to be solved in.

For Ex: I have a Databse of 50 questions, each question assigned different timings depending on their complexity and for various level openings.

I would like to pick up randomly any no of questions and get the Total Time Displayed in the Cell G3 and in the Second Sheet where it has a look of an exam it should have a CountDOwn Timer after the Candidate clicks on the Start Button and it Should have a Count-Down Timer which should be Dynamic to pick up the Total Time from the no of selected questions for the Test as well as should Disable the Sheet once the Time reaches zero...

It can also promt the user of the Last 5 minutes to go...The Candidate can click on Submit button to complete the Test ..

Can this be possible..It would be really helpful as the current procedure is time-consuming and also not very reliable..
I am not sure whether this is only possible in only VBA thats the reason posted the query in WorkSheets Functions but please if its not then can be moved...

Warm Regards..
e4excel

**e4excel** · 11-20-2009, 04:37 PM

Dear Forum,

Can someone help me with this Please it will help me immensely to reduce the workload...

**e4excel** · 11-22-2009, 08:10 AM

I have found a file for my use in google, however I do not know how to customise the same due to lack of knowledge in VBA..

Can some please help me with the explantions wherever possible as I am not able to understand the syntax.

I do not want the cells to be merged as some of the cells are merged..

Like mentioned in the first post for this thread I am using this logic for running a small test for the HR Dept in the recruitment process and need it be changed so need to understand the nunaces to be able to use it for the specific purpose.

Warm Regards
e4excel