00:00Here is how you can create a real-time clock in your Excel worksheet. Start off by pressing
00:04alternate F11 to launch your VBA editor and paste this VBA subroutine. If you like a copy of this
00:10VBA subroutine, please leave a request on the comment section and I'll show you how you can
00:14get it. Now press ctrl s to save and close your VBA editor here. Next thing you have to do
00:19is go
00:20to developer ribbon, under controls, go to insert and under form controls, you're going to insert a
00:25button anywhere on your worksheet like this and after that assign the macro called toggle start
00:31stop real-time clock and click on ok. Make sure you're off the design mode and click anywhere else
00:38on your worksheet. Now if you click on the button here, the clock on your worksheet get updated at
00:43real-time.