Excel - Exact Time by Keystroke: Episode 1724

1,223 views · Published 5 June 2013 · 3:49 · Indexed 25 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Enter the Exact Time to the Second with a Keystroke | MrExcel Podcast.

Welcome to another episode of the MrExcel podcast! In today's episode, we will be discussing how to use a simple keystroke to display the exact time to the second in an Excel spreadsheet. This question was sent in by James T. on YouTube, who needed to calculate the duration of phone calls in his spreadsheet. 

To achieve this, we will be using the shortcut keys Ctrl+: or Ctrl+Shift+; to insert the current time into a cell. However, if the columns are not formatted to show time down to the second, the shortcut will not work. In order to fix this, we will need to use VBA (Visual Basic for Applications). 

To do this, we will switch over to VBA by pressing Alt+F11. From there, we can insert a module and name it "ExactTime". In this module, we will use the system variable "Time" to display the exact time to the second in the active cell. We will also add a line of code to format the cell to military time, but this can be changed to AM/PM if desired. 

To make it even easier, we can assign a shortcut key to this macro by going to Options and choosing a key combination. For example, we can use Ctrl+T to insert the exact time into a cell. And for James' specific needs, we can add an additional line of code to automatically move to the next column after each entry. 

This simple solution allows for easy data entry and analysis, making it a useful tool for tracking the duration of phone calls or any other time-related data. Thank you to James for sending in this question and thank you for tuning in to another netcast from MrExcel. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Exact Time to the Second via Keystroke 
(00:10) Solution using Ctrl+: or Ctrl+Shift+; 
(00:26) Formatting columns to show time down to the second 
(00:36) Switching to VBA 
(01:03) Creating a macro for exact time 
(01:13) Assigning a shortcut key 
(01:54) Making it easier for data entry 
(02:12) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Assigning shortcut keys in Excel
Automatically moving to the right in Excel
Data analysis in Excel
Data entry in columns A-D
Exact time to the second
Formatting cells for military time
Keystroke shortcut for time
Logging data in Excel
VBA macro for exact time


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153546/


James is looking for a Keystroke to enter the Exact Current Time, to the Second, in a Cell. You would think this would be a 30-second podcast, but you would be wrong. Today, a small Macro to improve the Ctrl+Colon Shortcut. Follow along with MrExcel in Episode #1724 as he shows us how to create a very simple Macro that is activated by easy Keystrokes to Enter Exact Time. *If you've been curious about VBA and would like to try it, but want something simple, open up a new Workbook and try this one yourself! This is a simple project and a rewarding one as well.

Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful and useful. http://www.mrexcel.com/store/index.php?l=product_detail&p=257  

For more information on Excel 2010 VBA and Macros, check out...

VBA and Macros: Microsoft Excel 2010 - The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions. Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens -- or even hundreds -- of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. http://www.mrexcel.com/store/index.php?l=product_detail&p=186 

"The Learn Excel from MrExcel Podcast Series"

Visit us: MrExcel.com for all of your Microsoft Excel Needs!

More from this channel