It’s always handy to be able to insert current time using Excel current time formula or keyboard shortcuts in cells. In this article, we demonstrate multiple ways to display the current time in Excel.
In the above screenshot, we overview some of the easiest ways to fetch current time in Excel.
Download Excel Workbook
In the case of entering time in Excel, if you type 11:30,15:20 or 17:00 PM Excel understands the values as time inputs. Excel displays these kinds of values as 11:30/11:30 AM, 15:20/15:20 PM, or 17:20/17:20 PM depending on the default time format.
In our case, we just use different formulas to come up with the current time in Excel.
And the formulas display the current time in format types like Custom, Number, and General. But these are not the formats we want our data in. So, what can be done?
We can change the formatting of the values and display them in our desired formats by simply following below steps:
Step 1: Select all the current time values, then Go to Home Tab > Click on Font Settings Icon.
Step 2: The Format Cells window appears. In the Format Cells window, Select Number Tab > Choose Time as Category > 1:30:55 PM as Type. You can use other options as Type to display the current time.
You can use keyboard shortcuts CTRL+SHIFT+F or CTRL +1 to bring out the Format Cells window.
After returning to the dataset, we’ll see all the formula times are formatted in a specific format that we chose momentarily ago.
7 Easy Ways to Use Excel Current Time Formula
Before applying any of the below methods, it’s ideal to preformat the cells with desired time format as shown in the Applying or Changing Time… section.
Method 1: Using Keyboard Shortcuts (Static Excel Current Time)
Excel offers keyboard shortcuts to fetch current time in any cells in excel.
➤ Press CTRL+SHIFT+; to display the current time in any random cell.
For MAC, the shortcut key is COMMAND + ;
⧬ Keep in mind that keyboard shortcuts display the current time of any moment and make it static unless shortcuts keys are again pressed.
Method 2: Using NOW Function (Dynamic Excel Current Time)
Microsoft Excel offers multiple functions to deal with time. However, the NOW function fetches the current time every time you recalculate or revisit the data.
➤ Type the below formula in any blank cell (i.e., C5).
Afterward, the formula displays the current time in the cell as shown in the following image.
⧬ Use SHIFT+F9 to insert current time in active worksheets and F9 to insert current time in all open workbooks. The NOW function displays the current Date and Time altogether; Apply formatting to display only the current Time in any cell.
Method 3: Combining NOW and INT Functions as Excel Current Time Formula
The INT function rounds a number to the nearest integer. Normally, you get decimal when you apply the NOW function.
➤ Paste the following formula in any cell then Press ENTER.
The NOW function just fetches time from the computer system. Then subtracting INT(NOW()) from NOW results in only decimals and it only displays the current time as depicted in the following picture.
- How to Use DAY Function in Excel (With 3 Examples)
- Use SECOND Function in Excel (3 Examples)
- How to Use MINUTE Function in Excel (6 Examples)
Method 4: Using TIME Function to Bring Out Excel Current Time
The TIME function takes three arguments (hour, minute, second) to display time. However, it doesn’t display the current time. To display the current time, we have to entwine the NOW function with it.
➤ Write the
=NOW() formula in any blank cell (i.e., C5) then Press ENTER.
The current time appears in cell C5.
➤ Paste the below formula in cell C6 to assign current time to TIME function’s arguments.
In the formula, C5 is assigned as a cell reference to the arguments.
You can see the same time appears in cell C6.
You can also use the NOW function in the place of the cell reference to fetch the current time using the TIME function. In that case. The formula becomes
Method 5: Using TEXT Function as Excel Current Time Formula
The TEXT function converts a numeric value into a text string. We can assign the NOW function as a numeric value and provide a specific format to result in. The syntax of the TEXT function is
➤ Insert the following formula in any cell (i.e., C5) and Hit ENTER.
Inside the formula,
hh:mm:ss AM/PM= format_text, you can assign any format to display the time in.
Method 6: Using NOW and TODAY Functions to Get Current Time in Excel
The NOW function displays the current Date and Time in none-preformatted cells. Whereas the TODAY function only displays the current day. Subtracting TODAY from NOW results in only the current time.
In this method, we fetch current time from the subtraction of NOW and TODAY.
➤ Write the following formula in any blank cell (i.e., C5) after that Press ENTER.
You’ll get the time as shown in the above screenshot.
Method 7: Using Excel HOUR, MINUTE and SECOND Functions
The HOUR, MINUTE, and SECOND functions take only one argument as serial_number individually. Though these functions don’t display the current time, we can patch them with the NOW function to show the hour, minute, and second separately. Then add them using Ampersand (&) to make up the current time.
➤ Type the below formula in any blank cell (i.e., C5).
➤ Repeat the above step with MINUTE and SECOND formula as shown in the following image.
➤ Write the below formula in any cell (i.e., C9) to join the hours, minutes, and seconds and constitute the current time.
The Ampersands (&) join hours, minus, and seconds to constitute the current time in the cell.
In the article, we demonstrate multiple ways to insert current time in Excel. We use multiple functions such as NOW, TIME, TEXT, INT, TODAY, HOUR, MINUTE, and SECOND as well as keyboard shortcuts to fetch current time. We discuss time formatting types as most of the functions result in different values without pre-formatting. Hope the above-described methods of Excel’s current time formula intrigue you to use time data more efficiently. If you have further queries or feedback, please let me know in the comment section. You can check out my other articles on the Exceldemy website.
- How to Use TIMEVALUE Function in Excel (4 Examples)
- Use WEEKNUM Function in Excel (2 Ways)
- How to Use Excel MONTH Function (6 Examples)
- Use YEAR Function in Excel (5 Examples)
- How to Use DAYS Function in Excel (7 Examples)
- Use DATEDIF Function in Excel (2 Examples)
- How to Use WORKDAY Function in Excel (5 Examples)