How to Create Mutiple Countdown Timers In Excel
Hi Everyone
I wonder if someone can help I am trying to create multiple Countdown timers within Excel to help keep track of time a particular task takes me but I am having some trouble understanding the VBA Coding to help with this.
Are there any links to help learn VBA Coding or does some one have any code written up already
Many Thanks for all your help
You don't need "Timers" as such.......... If you log the start date/time and end date/time you can calculate the duration by just subtracting the start from the finish.
Elegant Simplicity............. Not Always
Hi Andy thanks for the reply.
What I mean is if a task allocates 30 minutes for you to complete you press start and timer counts down and you can pause the timer as well
In that case you need to :-
a) Log the start time of each task
b) Know the Estimated time of each task
and
c) Use Application.Ontime to periodically check progress.
... bearing in mind that a macro steals control from the user so if you run the Ontime macro too often the user won't get chance to complete and log the work done
Last edited by AndyLitch; 04-26-2013 at 06:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks