How to create Running Clock in Excel | Analog Clock in Excel | Digital Clock in Excel

This video will teach you how to create running clock in excel | Analog Clock in excel | Digital clock in excel.

innovative ideas using Doughnut Chart.
how to make clock in excel

SSuggested Videos:
Split names in Excel - First Middle Last :
Excel Add ins | Custom Function - Formula What! You Want (Hindi):

Suggested Playlist
Vlookup Series :
VBA full course in Hindi :

Please click the Subscribe button and comment, like and share. I appreciate your support!

[ValueLearnings]

VBA Script👇
----Run this macro to create the hour points----👇
Sub CreateHourPoints()
'run this macro to create the hour points
1").Select 'Change chart name here
For x = 1 To 120
If x Mod 10 = 0 Then
= RGB(51, 51, 0)
End If
Next x
End Sub


----Run this macro to start the clock---👇
Sub DoughnutFormat()
'this macro will start the clock
1").Select 'Change chart name here
x = Second(Now())
= RGB(195, 214, 155)
+ 1).Format.Fill.ForeColor.RGB = RGB(0, 0, 0)
Range("b3") = WorksheetFunction.Text(Now(), "hh:mm")

Application.OnTime Now() + TimeValue("00:00:01"), "DoughnutFormat" 'Change Procedure name here
End Sub

[DeepakSingh-lx]

Hello sir, kya ap meri ek query solve kr sakte hai.
Column A m kuch text h or Column B m mene Vlook up k through kuch text show kiye hai. ab mein Column A and B k text ko match krna cahta hu k kon se match kr rhe hai kon se nhi to kaise krenge ye chiz.. Actually abhi ek column m text or dusre m formula hone ki wjha se match krne pr hamesha False aarha h..

Column A | Column B | Column C
Shubham | (=Vlookup) Shubham | =A1=B1 (False)

Please help