Excel Countdown

tsmia165
tsmia165 used Ask the Experts™
on
Experts,
 I have a code that I found on another site that allows me to give a specific time and an automatic count down with a continue, pause and stop button. What I need is the ability to add multiple countdowns on the same page. I will be using this for a mechanic shop and showed on a LCD screen outside on the shop so that the techs know how much time they have left on the job.

I have attached the excel sheet for your needs

countdown1.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Your spreadsheet has a label called "Time Left" and another called "Time Given". I don't understand what these mean. When you run the macros, Time Left counts down from midnight. ??????

Wouldn't it make more sense to have something like this:

JOB           Started At        Time Given        Time Left
------------------------------------------------------------------------

17               2:45:00 PM         10 min             7:38      [minutes and seconds, counting down]
18               2:53:14 PM         15 min             13:52

etc.

Author

Commented:
Yes Iwebber, That format is better, aslong as I stil have the ability to pause a job and restart it at the same time left.

Commented:
To project on LCD the http://www.xnotestopwatch.com is much more suitable.
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Author

Commented:
That does not work for me and how i need to use it.  Thanks
It sounds like you are using excel for a time management type system.. for billing I would bet..   Is it possible that you are really wanting to just calculate the time they took on a job or are you really having them work vs a clock?  if vs a clock then why dont you have the program loop thru the end times and compare it vs the alarm value and if it is in alarm then make a note of it..
ex..
Col A        col b          col c            col d            col e
Name      status        starttime      endtime        note
jack         active        9:00            9:30            
bob         paused      9:23            1:00

loop thru col b
if b=active check current time vs cold  if > then alarm and place note in col e

use a timer to loop thru it say every minute..

Author

Commented:
Nope Webber has the idea and how i need to use it.

Thanks
well counting down and checking schedule are the same just when you check you write the current time..  in a column.. as elapsed time.. pretty easy and only 1 timer.

Commented:
Try this out. In the TimeGiven cell, you have to enter the time in h:m:s format. For example, 30 seconds would be 0:0:30.
Job-Timer.xlsm

Commented:
In case you're using an older version of Excel, use the attached.
Job-Timer.xls

Commented:
I should have given a bit more instructions. To create a new timer, click the cell marked NEW. To use any of the other commands, click the cell (Start, Stop, Delete, Pause, Resume, etc.).

Author

Commented:
Webber, I am geting a run time error 1004 - Method Range of object_Worksheet failed.

Thanks
Commented:
You must be using the .xls one. I forgot to redefine the ranges in it. Here's a replacement.
Job-Timer.xls

Author

Commented:
Great Job!!!! Thank you so much!!
lwebber.. nice job

Author

Commented:
Webber, one more thing can we make the whole line turn red when the time has expired?

Thanks

Commented:
Sure. Go into the VBA code and open the modTimer module. Change the line:

                timeLeftCell.Font.Color = vbRed

to

                jobSheet.Rows(timeLeftCell.Row).Font.Color = vbRed

Author

Commented:
Thank you!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial