Want to add a real-time clock to your Excel sheets?

@excelcampus

199.5K followers · usually 2.3K views a post

Views

35.4K

Likes

968

Comments

8

Shares

562

SoundTikTok sound · original sound - excelcampus

Promoted product

Excel

Learn and practice dozens of Excel functions and tools online for free - from beginners to pro level, without the need to download any files.

18 videos10 creators

Why it worked

The video provides a practical and visually appealing solution to a common Excel user need, using a clear step-by-step demonstration and offering downloadable code for easy implementation.

Summary

This video demonstrates how to add a real-time digital clock to an Excel sheet using a combination of the NOW() function and VBA code. It also suggests downloading a digital font style to enhance the clock's appearance.

Structure

1Introduce the problem: adding a real-time clock to Excel.
2Enter the NOW() formula and format the cell.
3Open the VBA editor and insert a module.
4Paste and run the provided VBA code.

Original caption

Ever wondered how to keep track of time directly in your Excel sheets? 🕒 Adding a real-time clock can enhance your productivity and help you stay on top of tasks! Discover this quick and easy method to embed a clock seamlessly. It’s simpler than you think! Let’s get started and transform the way you work with Excel. ✨ 📌Download Free VBA Keyboard Shortcuts: https://www.excelcampus.com/vba-shortcuts/ ➡️CODE: Sub Digital_clock() Range("B3").Value = Now Application.OnTime Now + TimeValue("00:00:01"), "Digital_clock" End Sub #ExcelTips #Excel #Finance #Spreadsheets #productivityhacks #Exceltricks #office #Accounting #Microsoftexcel #timemanagement

More from @excelcampus

Product placement

Excel: A spreadsheet program used to organize and analyze data. It ACTS as the platform for the digital clock. Removing it would change what happens in the video. Excel Campus: A website or brand that provides Excel tutorials and resources. It APPEARS as a watermark and in the end screen. Removing it would not change what happens in the video.

Call to action

Download Free VBA Keyboard Shortcuts

On-screen text

DIGITAL CLOCK 08:22:04 AM Want to add a real-time clock to your Excel sh Here's a quick w to do it! Select the cell Ent to display the current date Press Ctrl + ; Ctrl + 1 Date 1/27/2025 1:30:55 PM 13:30:55 OK 08:20:43 AM Digital Clock 08:21:32 AM 08:21:34 AM 08:21:36 AM to make it look like a real digit download a digital font style Like 'Digital 7' from the web 08:22:04 AM That's it! A real time clock Perfect for dashboards, attendance and live reports Excel Campus Free VBA Shortcuts VBA Keyboard Shortcuts List How to Press the Shortcut Keys Insert another module. Download the PDF Version Click the link below to get a printable PDF version of this page with over 25 VBA shortcuts. Download VBA Keyboard Shortcut.pdf (208 KB) Download Free VBA Keyboard Shortcuts excelcampus.com/vba-shortcuts

Transcript

Want to add a real-time clock to your Excel sheets? Here's a quick way to do it! Select the cell where you want the clock to appear and enter this formula =NOW() to display the current date or press Ctrl + ; to display the current date. Press Ctrl + 1 to open Format Cells. Choose Time and select your preferred time format, then press OK. Now right click on the sheet tab at the bottom and select View Code. In the VB editor that opens, go to Insert and select Module. Paste this code. I'll pin the code in the comments below for easy reference. Sub Digital_clock() Range("B3").Value = Now Application.OnTime Now + TimeValue("00:00:01"), "digital_clock" End Sub Click this to run the code or Press F5. And your clock will start ticking. To make it look like a real digital clock, download a digital font style like 'Digital 7' from the web. That's it! A real time clock. Perfect for dashboards, attendance and live reports.

Are you tired of scrolling endlessly through your Excel sheets to find what you

34.4

78.4K3.7K123

Excel Keyboard Shortcuts

78.4Kviews@excelcampus

Are you curious about how to effectively track your weekly progress in Excel? 📊

12.8

29.3K9964

Excel

29.3Kviews@excelcampus