Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Display the Current Time in Excel

Excel can display the current time using the NOW function. This step by step tutorial will assist all levels of Excel users in calculating a time difference in different formats.

Figure 1. Final result

Syntax of the NOW formula

=NOW()

The NOW function has no parameters and returns the current time and date. To get only the time we will need to format the cell accordingly.

Setting up Our Data for Displaying the Current Time

Our table consists of 2 columns: “Current Time” (column B) and “Format ” (column C). In column B, we want to get a current time, while in column C we have a format of the appropriate time.

Figure 2. Data that we will use in the current time displaying

Displaying the Current Time

In our example, we want to display the current time in the cell B3 in format h:mm:ss AM/PM. Before applying the formula, we must set the format of the resulting cell as a time. To do this, we need to press Ctrl+1, choose “Custom” category and enter the format of the time – h:mm:ss AM/PM.

Figure 3. Formatting the cells for displaying the current time

Formula:

=NOW()

Setting the cell format like this, we will get the current time in hours, minutes and seconds and AM/PM.

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.

To get the current time using the NOW formula, we need to follow these steps:

  • Select cell B3 and click on it
  • Press Ctrl+1
  • Choose “Custom” category and enter the format of the time – h:mm:ss AM/PM
  • Insert the formula: =NOW()
  • Press enter

  • Select cell B4 and click on it
  • Press Ctrl+1
  • Choose “Custom” category and enter the format of the time – h:mm AM/PM
  • Insert the formula: =NOW()
  • Press enter

  • Select cell B5 and click on it
  • Press Ctrl+1
  • Choose “Custom” category and enter the format of the time – h:mm:ss
  • Insert the formula: =NOW()
  • Press enter

  • Select cell B6 and click on it
  • Press Ctrl+1
  • Choose “Custom” category and enter the format of the time – h:mm
  • Insert the formula: =NOW()
  • Press enter

Figure 4. Displaying the current time in different formats using the NOW formula

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. 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. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
I would like my result cell to display 1 of 5 values: If my referenced cell value is less than 2 then the result cell should display 2. (values 0 thru 1.99 = 2) but if my referenced cell value is greater than 2 but less than 2.99 then the new cell should display 3 (values 2 thru 2.99 = 3) but if my referenced cell value is greater than 3 but less than 4.99 then the new cell should display 5 (values 3 thru 4.99 = 5) but if my referenced cell value is greater than 5 but less than 7.5 then the new cell should display 7.5 (values 5 thru 7.5 = 7.5)
Solved by S. Q. in 15 mins
i want to insert a multiplication formula in a cell if some percentage value is entered in another cell of same row. for eg. if i put a formula in G7 cell (=G2*e7) but it should be enabled or activated if i put some data entry in f7 cell Excel
Solved by Z. D. in 20 mins
Do I have to pay for a solution ? I just wasted time with another help desk that asked for $46 for an answer. If that is the case, thanks anyway.
Solved by X. U. in 18 mins
i would like the cell to become red if the date in the cell exceeds "NOW"
Solved by K. F. in 20 mins
I have =NOW() in A2, and deadline dates in Column K What I am looking for is the correct conditional formatting, to give me a 1. yellow highlight when within 7 days 2. red when the deadline has passed
Solved by D. D. in 23 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc