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
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 with times.
- Then, click the right-click button, it will open the dialog box.
- You can see the “Format Cells” option in the list.
- Click the “Format cells” option, it will open the window as per the given image.
- Here, you need to select the “Time“ 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.
- Finally, the input times will turn to the format that you selected.
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.
Top comments (0)