How to Create Running Clock in Excel? - Excel Charts
Вставка
- Опубліковано 20 лип 2024
- 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 UA-cam Channel.
Have a good day!
Great job dude
I'll also try this,
Thanks again for this awesome watch formula
Thanks for your appreciation!
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?
Excellent. I really enjoyed following along making this. Thank you
This is good work. Excellent !!!
Wow, great job brother 😍👍
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
Great job sir
Excellent!
Amazing 😉
can it still work if we change the numbers (1 to 12) with texts (one to twelve) instead? just for a variation
ok, sir, I will try again....thanks
Hi brother amazing video. Is it possible to do clock or timer in online Excel?
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.
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.
Very good
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
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
Not able to create the lines of second hr and min
mantab bro,,
di chanel ku akan ku buat versi bahasa indonesia
sir, please can you share the file for download
Hi, when I press the F9 key, the screen turns black. Is there another way to trigger the clock?
You can use VBA code to refresh on ever second. Thanks
@@thedatalabs Oh. Thanks for the quick reply!
@@thedatalabs can you describe how ?
I did exactly as you instructed but it didn't work.
Dear sir, I will try but run time error,424, showing.clock not working
Thanks for watching! Make sure you have declared the object before using or referring. Check variable declaration as well.
sir after close the file and again open time clock not working
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
I hit F9 and then the time got adjusted but it doesn't move continuously. I have to keep hitting F9
Please use VBA code to run automatically
@@thedatalabs Where is the VBA code located?
I made it. But it's not moving automatically. Would you pls tell me that whether I've to press any button for this?
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.
@@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
Good one bro. But at the beginning you are very fast. Go Slow. It's a request.
Sure, I will take care in future videos. Thanks for your feedback!
BHAI BOHOT MUSHKIL Hai koi easy way battaoooooooooooo
Thanks for your feedback! I will post an updated tutorial.
Sir please starting me jo time laye hai rest wala vo kaise laye hai bhut fast ho gya h video
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.
=MINUTE(NOW()) you need to write like this i was missing the same as you are getting....it will work
Needels are not joining at a point
its not working
Hard to follow ..... I guess you made and other pie chart or two .... I got lost after first hand
Yes, it's combination of Pie charts. It's very simple to create. Please watch this again. Thanks!
@@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.
I got the issue and fixed, now clock working perfectly. Thanks
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.
@@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.
I am leaving u dont replly
अगर दिल से नहीं सिखाना है तो वीडियोज क्यों अपलोड करते हो।फार्मूले कौन सिखाएगा?
ur videos need to be a little slow
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
ok i figured it out :) Thank you again
@@DrPZB1 How please!