Change the Time Format in Excel Office 365 ~ Useful Guide!!
Tags: excelpreface, changetimeformat, excelbasics, exceltutorials
Published: 2021-01-18 04:05:19

---
title: Change the Time Format in Excel Office 365 ~ Useful Guide!!
published: true
date: 2021-01-17 10:55:48 UTC
tags: ExcelPreface,Changetimeformat,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/change-the-time-format-in-excel/
---

So far we have learned how to enter the time in Excel. Normally, when you insert a time in a cell it is displayed in the format **HH:MM:SS**. You can also change it into different time formats as per your convenience. Let’s see the below steps to **change the time 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 change the time format:

Please do follow the below steps to change the time format in the Excel sheet.

- First, you need to enter the time on your worksheet and select the [cells](https://geekexcel.com/excel-cells-options/) with times.

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

- Then, click the right-click button, it will open the dialog box.

![Right-click option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Right-click-options.png)<figcaption id="caption-attachment-21051">Right-click option</figcaption>

- You can see the **“Format Cells”** option in the list.

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

- Click the **“Format**   **cells”** option, it will open the window as per the given image.

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

- Here, you need to select the **“[Time](https://geekexcel.com/how-to-convert-time-to-seconds-minutes-hours-in-excel-office-365/)“** option on the left side of the window, and you can see the different time formats on the right side.
- You can select any time format as you wish then click the **“OK”** button.

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

- Finally, the input times will turn to the format that you selected.

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

## Conclusion:

In this useful guide, we explained the simple steps to **change the time format in Excel**. If you have any **doubts,** kindly let me know. I reply to **queries** frequently.

### Read Also:

- **[Enter the Date in Excel Sheet ~ Step-by-Step Procedure!!](https://geekexcel.com/enter-the-date-excel/)**
- **[How to use Excel TIME Function in Office 365? Examples](https://geekexcel.com/how-to-use-time-function-in-excel-365/)**