We have already learned how to enter the date in Excel. Similarly, here we are going to learn how to enter a time in the worksheet. By default, the timeis “HH:RR:MM” format in Excel. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Steps to enter a time:
For instance, we are going to enter the time of “5:30:45” in the Excel sheet.
- First, you need to select the cell where you want to enter the time.
- Type the hour “5” from the keyboard.
- After that, type the separator “:” (i.e. colon).
- You need to enter the minute by type “30”.
- Then, type another colon separator and enter the seconds “45”.
- Now, you can see the time on your worksheet.
Steps to enter a current time:
There are a number of quick tricks for entering the current time on your worksheet. Let’s see them below:
Using the NOW function:
- You can use the NOW function, you can get the current time.
=NOW()
- Enter the above formula in the cell, it will display the current time.
Using the Shortcut:
- You can also use the shortcut key to display the current time in your worksheet.
- Just press the CTRL + SHIFT + ; (semicolon) keys to return the current time.
Bottom-Line:
In this useful article, we have described the simple and easy steps to enter the time on your worksheet in Excel. If you have found any mistakes in this article, don’t forget to share them with us. To learn more, check out Geek Excel!!
Top comments (0)