How to Create Running Clock in Excel? - Excel Charts

[@chiptaylor1124]

Excellent. I really enjoyed following along making this. Thank you

[@adamgatley8217]

This is amazing ...is it possible for you to add a link in the description where we can download this clock ...I am very new to excel and would love to study it to see how it works?

[@kb7417]

I dont understand why most of the people in comment are saying cannot execute or have problem I did it and I was on point on the first attempt. Be patient and watch the vidoe full at first then follow along then try doing yourself. This way you can learn.

[@hadikk7111]

Wow, great job brother 😍👍

[@ranajaydey4559]

Great job, the formulas for Hours, Minute, Second and Rest in the first module (Actual Hours) all are complete as per your guideline for me although I did everything. But clock needle not auto run after VBA code. So, how to solve it

[@vikassam97]

Great job dude I'll also try this, Thanks again for this awesome watch formula

[@thedatalabs]

Thanks for your appreciation!

[@mraza99]

This is good work. Excellent !!!

[@romlef526]

Very good

[@vilasdhote3847]

Great job sir

[@MegaDeepak1982]

ok, sir, I will try again....thanks

[@rahulrajopadhye]

Excellent!

[@fabriciocarranza7044]

Amazing 😉

[@grizzly-channel]

can it still work if we change the numbers (1 to 12) with texts (one to twelve) instead? just for a variation

[@Hamza_lakhani_]

BHAI BOHOT MUSHKIL Hai koi easy way battaoooooooooooo

[@thedatalabs]

Thanks for your feedback! I will post an updated tutorial.

[@waytofoodmoodtravel7958]

Hi Bro, in middle when we are taking needles I m getting too much issue. I insurted that hour chart after only single needle how to remain i m getting that point. can please tell how saperate that needle form pai chart please please please

[@nileshtikekar3235]

Good one bro. But at the beginning you are very fast. Go Slow. It's a request.

[@thedatalabs]

Sure, I will take care in future videos. Thanks for your feedback!

[@ZulkarnainPane]

mantab bro,, di chanel ku akan ku buat versi bahasa indonesia

[@MohanKumar-mb3yh]

How to add function to pause the clock when the machine is locked and show the logs for all pauses occurred. Can please anyone suggest.

[@ranakhalidmahmood5837]

did it need special Exel, I tried many time but second needle not move and not grouped..I have ccore i3 with window xp . can any body help me . as i am learning as student

[@svijayiitk]

Hi, when I press the F9 key, the screen turns black. Is there another way to trigger the clock?

[@thedatalabs]

You can use VBA code to refresh on ever second. Thanks

[@svijayiitk]

@@thedatalabs Oh. Thanks for the quick reply!

[@jamalariffin7606]

@@thedatalabs can you describe how ?

[@AlwinSandeep]

I hit F9 and then the time got adjusted but it doesn't move continuously. I have to keep hitting F9

[@thedatalabs]

Please use VBA code to run automatically

[@Mouqvist]

@@thedatalabs Where is the VBA code located?

[@AjaySharma-em2ez]

sir, please can you share the file for download

[@MegaDeepak1982]

Dear sir, I will try but run time error,424, showing.clock not working

[@thedatalabs]

Thanks for watching! Make sure you have declared the object before using or referring. Check variable declaration as well.

[@MegaDeepak1982]

sir after close the file and again open time clock not working

[@thedatalabs]

It should work. Please send me the file to below email id so that I can check and let you know the real issue. [e-mail]

[@kritika_vishwakwarma]

Sir please starting me jo time laye hai rest wala vo kaise laye hai bhut fast ho gya h video

[@abhishekdas8503]

Not able to create the lines of second hr and min

[@ThanhVuHai]

I did exactly as you instructed but it didn't work.

[@IULIANURSU]

Great job, although it's quite difficult to follow. You're moving too fast. Also, the formulas for HOurs and Rest in the first module (Actual Hours) does not work for me although I did everuthing exactly as in the video.

[@MuhammadZubairAsifi]

=MINUTE(NOW()) you need to write like this i was missing the same as you are getting....it will work

[@aparnaananthula3283]

Needels are not joining at a point

[@tradingrobots6052]

Hard to follow ..... I guess you made and other pie chart or two .... I got lost after first hand

[@thedatalabs]

Yes, it's combination of Pie charts. It's very simple to create. Please watch this again. Thanks!

[@mokarramraza]

@@thedatalabs Hey, you select data point after no fill that time two data point, when you select then one disappear and one converting in needle, but when i am doing the I can't covert a data point as needle. selection moment did no see while may time watched this vedio.

[@mokarramraza]

I got the issue and fixed, now clock working perfectly. Thanks

[@TheRamsbod]

I can't seem to just select the needle part. How do you do this. When I click on the line it selects the whole pie section.

[@markcox3068]

@@TheRamsbod I found that if you increase the needle value a little (say 0.2 instead of 0.02), I can select it more easily. Once the needle is filled in how you want, change the needle value back to 0.02.

[@swapniljaiswal3127]

its not working

[@abhishekdas8503]

I am leaving u dont replly

[@virendrabhardwaj5505]

अगर दिल से नहीं सिखाना है तो वीडियोज क्यों अपलोड करते हो।फार्मूले कौन सिखाएगा?

[@abhishekdas8503]

ur videos need to be a little slow

[@DrPZB1]

Thanks for making this it was awesome. my first intro into macros. however i need a help when trying to run it i get compile error : " End If without block If" can you help ? Private Sub ToggleButton1_Click() If ToggleButton1.Value = True Then ToggleButton1.Caption = "STOP" x: Application.Calculate DoEvents If ToggleButton1.Value = False Then ToggleButton1.Caption = "START" Exit Sub End If GoTo x End Sub Thank you

[@DrPZB1]

ok i figured it out :) Thank you again

[@AbbassiTarek]

@@DrPZB1 How please!