How to Create Running Clock in Excel?

How to Create Running Clock in Excel? - Excel Charts

Рет қаралды 55,257

Күн бұрын

In this video, we will learn how to create a live Wall Clock in Excel with the help of Pie Chart. This is really awesome Excel tips. You will be surprised to see the versatility of Excel features.
#LiveClock
Thanks for Watching!
Please subscribe our KZfaq Channel.
Have a good day!

Пікірлер: 57

@mraza99 2 жыл бұрын

This is good work. Excellent !!!

@vikassam97 5 жыл бұрын

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

@thedatalabs 5 жыл бұрын

Thanks for your appreciation!

@chiptaylor1124 10 ай бұрын

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

@rahulrajopadhye 3 жыл бұрын

Excellent!

@vilasdhote3847 4 жыл бұрын

Great job sir

@fabriciocarranza7044 4 жыл бұрын

Amazing 😉

@hadikk7111 2 жыл бұрын

Wow, great job brother 😍👍

@MegaDeepak1982 5 жыл бұрын

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

@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 3 жыл бұрын

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.

@ranajaydey4559 2 жыл бұрын

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

@hussainsheriffj3506 3 жыл бұрын

Hi brother amazing video. Is it possible to do clock or timer in online Excel?

@romlef526 2 жыл бұрын

Very good

@grizzly-channel 2 жыл бұрын

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

@ZulkarnainPane 3 жыл бұрын

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

@MohanKumar-mb3yh 3 жыл бұрын

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 3 жыл бұрын

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

@waytofoodmoodtravel7958 2 жыл бұрын

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 3 жыл бұрын

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

@thedatalabs 3 жыл бұрын

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

@Hamza_lakhani_ 2 жыл бұрын

BHAI BOHOT MUSHKIL Hai koi easy way battaoooooooooooo

@thedatalabs 2 жыл бұрын

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

@AjaySharma-em2ez 2 жыл бұрын

sir, please can you share the file for download

@svijayiitk 4 жыл бұрын

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

@thedatalabs 4 жыл бұрын

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

@svijayiitk 4 жыл бұрын

@@thedatalabs Oh. Thanks for the quick reply!

@jamalariffin7606 2 жыл бұрын

@@thedatalabs can you describe how ?

@ThanhVuHai 4 жыл бұрын

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

@abhishekdas8503 3 жыл бұрын

Not able to create the lines of second hr and min

@AlwinSandeep 4 жыл бұрын

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

@thedatalabs 4 жыл бұрын

Please use VBA code to run automatically

@Mouqvist 2 жыл бұрын

@@thedatalabs Where is the VBA code located?

@MegaDeepak1982 5 жыл бұрын

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

@thedatalabs 5 жыл бұрын

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

@MegaDeepak1982 5 жыл бұрын

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

@thedatalabs 5 жыл бұрын

It should work. Please send me the file to below email id so that I can check and let you know the real issue. thedatalabs@gmail.com

@atishchakma7105 5 жыл бұрын

I made it. But it's not moving automatically. Would you pls tell me that whether I've to press any button for this?

@thedatalabs 5 жыл бұрын

Hi Anish, Thanks for watching! If you are using the underlying VBA code to refresh the chart then it will move automatically. You can also press F9 key to refresh the functions used in this chart. I would recommend you to use VBA code. Please refer description section for the link of file used in this video.

@grizzly-channel 2 жыл бұрын

@@thedatalabs Hi Sir, I've tried with the VBA code exactly as you mentioned but it returns a "compile error: End If without block if". I tried to add one more "End If" after the first IF statement but still didn't work. I wonder what is wrong with the code. Here it is: Option Explicit Private Sub tb1_Click() If tb1.Value = True Then tb1.Caption = "STOP" X: Application.Calculate DoEvents If tb1.Value = False Then tb1.Caption = "START" Exit Sub End If GoTo X End Sub

@kritika_vishwakwarma 2 жыл бұрын

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

@IULIANURSU 4 жыл бұрын

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 4 жыл бұрын

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

@aparnaananthula3283 3 жыл бұрын

Needels are not joining at a point

@tradingrobots6052 5 жыл бұрын

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

@thedatalabs 5 жыл бұрын

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

@mokarramraza 5 жыл бұрын

@@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 5 жыл бұрын

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

@TheRamsbod 4 жыл бұрын

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 3 жыл бұрын

@@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 4 жыл бұрын

its not working

@abhishekdas8503 3 жыл бұрын

I am leaving u dont replly

@virendrabhardwaj5505 3 жыл бұрын

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

@abhishekdas8503 3 жыл бұрын

ur videos need to be a little slow

@DrPZB1 2 жыл бұрын

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 2 жыл бұрын

ok i figured it out :) Thank you again

@AbbassiTarek 2 жыл бұрын

@@DrPZB1 How please!