How to Enter a Time in Excel Worksheet? ~ A Useful Guide!!
Tags: excelpreface, enteratime, excelbasics, exceltutorials
Published: 2021-01-18 04:04:08

---
title: How to Enter a Time in Excel Worksheet? ~ A Useful Guide!!
published: true
date: 2021-01-17 10:54:50 UTC
tags: ExcelPreface,Enteratime,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/enter-a-time-in-excel/
---

We have already learned how to **[enter the date in Excel](https://geekexcel.com/enter-the-date-excel/)**. Similarly, here we are going to learn **how to enter a time in the worksheet**. By default, the [**time**](https://geekexcel.com/how-to-use-time-function-in-excel-365/)is **“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](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.

![Select the cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-the-cell.png)<figcaption id="caption-attachment-20889">Select the cell</figcaption>

- Type the hour **“5”** from the keyboard.

![Enter the hour](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-hour.png)<figcaption id="caption-attachment-21039">Enter the hour</figcaption>

- After that, type the separator “:”  (i.e. colon).

![Type colon](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Type-colon.png)<figcaption id="caption-attachment-21040">Type colon</figcaption>

- You need to enter the minute by type **“30”**.

![Enter minute](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-minute.png)<figcaption id="caption-attachment-21041">Enter minute</figcaption>

- Then, type another colon separator and enter the seconds **“45”**.

![Enter second](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-second.png)<figcaption id="caption-attachment-21042">Enter second</figcaption>

- Now, you can see the time on your worksheet.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-25.png)<figcaption id="caption-attachment-21043">Result</figcaption>

## 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](https://geekexcel.com/how-to-use-now-function-in-microsoft-excel-365/), you can get the current time.

**=[NOW](https://geekexcel.com/how-to-use-now-function-in-microsoft-excel-365/)()**

- Enter the above formula in the cell, it will display the current time.

![NOW function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/NOW-function.png)<figcaption id="caption-attachment-21044">NOW function</figcaption>

### 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!!](https://geekexcel.com/)**

### Read Ahead:

- **[Enter the Date in Excel Sheet ~ Step-by-Step Procedure!!](https://geekexcel.com/enter-the-date-excel/)**
- **[How to Enter a Formula in Excel Office 365 ~ Easy Tutorial!!](https://geekexcel.com/how-to-enter-formula-in-excel/)**
- **[Excel Formulas to Add Hours/Minutes/Seconds to a Datetime!!](https://geekexcel.com/excel-formulas-to-add-hours-minutes-seconds-to-a-datetime/)**