Hello Excellence,
Can anyone explain how to start multiple countdown and count up time in particular column in excel. I think its possible. but i don't know how to do. can anyone helps me.
...Marc
Hello Excellence,
Can anyone explain how to start multiple countdown and count up time in particular column in excel. I think its possible. but i don't know how to do. can anyone helps me.
...Marc
Last edited by marc5354; 03-10-2010 at 12:04 PM.
Do you have a technique for starting ONE yet?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Sir... Can you please find attached file....
Like so... you need a second column to indicate whether each timer is UP or DOWN. Also, had to lose the MSGBOX since they stop all activity, throwing off the other timers that should still be running. Instead, we just change DOWN to DONE and "beep" so you know something ended.
Guru you are genius, i m not buttering you.
Simply you just solved my query. thank you very much for that.. You are god of Excel for me....
Sir..., One more thing if you know then teach me... Are there any way to start count down time and count up time without command buttons. like if i passed time in A10, at the same time B10 starts the count down time in this format hh:mm:ss when its equals to 00:00:00 C10 should starts the 00:00:01.
Thank you very much for your time and for your help
Marc
How about this:
Sir thank you very much for your hard work and for your time...
I appreciate you....
You are just close to my request, what i want... when i entered time B2 07:00:00 meantime in C2 starts 06:59:59 etc... but instead of that we can reset that count down time like 01:59:59.
thank you very muck sir..
Today i m very happy just because of your help...
God bless you rocket scientist
Marc
Just enter 02:00:00 as your starting time, not 07:00:00. As long as the sheet is paused, you can set as many starting times to begin together as you wish.
Actually, you only have to enter
2:
..to get the entry of 2:00:00
Alright thank you very much sir,
Now i m going to mark this post as solved. in future if i have any query please help...
Please promise me...
And add my friends request.
...Marc.
Sir,
Now i m facing some problem in macro.. please look into this matter...
...Marc
Fix this:
Please Login or Register to view this content.
Last edited by JBeaucaire; 03-05-2010 at 06:19 PM. Reason: needed that to be a 7
Sir
Now count down and count up both starting at the same time...
...Marc
Marc, you gotta get in there and fiddled with some of these numbers... try changing that 8 back to a 7...I offset from column C one column too many.
Thank you very much BOSS, Now its working ....
hahaha
you are Invincible...
...Marc
Hello Boss,
How are you doing now, can you please QC'd my attachment.
I added multiple time(s) with timezone...
Marc
Last edited by marc5354; 03-09-2010 at 11:51 AM.
Hello Boss,
How to a start clocks in excel zone wise in same sheet.. like EST CST MST PST AND HST etc.. Any idea..
...Marc
No idea. This a manual countdown start/stop process.
wow this is great job, i was in need of a a mutiple countdown with different controls to activate indivial cells
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks