quick way to insert current date in excel

If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Displaying the current time in different formats using the NOW formula Choose “Custom” category and enter the format of the time – h:mmįigure 4.Choose “Custom” category and enter the format of the time – h:mm:ss.Choose “Custom” category and enter the format of the time – h:mm AM/PM.Choose “Custom” category and enter the format of the time – h:mm:ss AM/PM.To get the current time using the NOW formula, we need to follow these steps: Similarly, in the cell B4, we want to get the current time in hours and minutes AM/PM, while in the cells B5 and B6 we at to get the current time in formats h:mm:ss and h:mm without AM/PM. Setting the cell format like this, we will get the current time in hours, minutes and seconds and AM/PM. Formatting the cells for displaying the current time Formula: To do this, we need to press Ctrl+1, choose “Custom” category and enter the format of the time – h:mm:ss AM/PM.įigure 3. Before applying the formula, we must set the format of the resulting cell as a time. In our example, we want to display the current time in the cell B3 in format h:mm:ss AM/PM. Data that we will use in the current time displaying Displaying the Current Time In column B, we want to get a current time, while in column C we have a format of the appropriate time.įigure 2. Our table consists of 2 columns: “Current Time” (column B) and “Format ” (column C). Setting up Our Data for Displaying the Current Time To get only the time we will need to format the cell accordingly. The NOW function has no parameters and returns the current time and date.

This step by step tutorial will assist all levels of Excel users in calculating a time difference in different formats.įigure 1.

Press and release the semi-colon key ( ) on the keyboard without releasing Command key.Excel can display the current time using the NOW function.

Press and hold the Command key on the keyboard.

The key combination for adding the date in Excel 2016 for Mac and Excel for Mac 2011 is: The current time is added to the worksheet.

Press and release the colon key ( : ) on the keyboard without releasing the Ctrl and Shift keys.

Press and hold both the Ctrl and the Shift keys on the keyboard.

Select the cell where you want the time to appear.To add the current time to a worksheet using just the keyboard: The key combination for adding the time in Excel 2019, 2016, 2013, 2010, and 2007 is: Although not as commonly used as dates in spreadsheets, adding the current time with a keyboard shortcut can be used, among other things, as a timestamp.

Quick way to insert current date in excel