In daily work Xi, if Excel is used for time statistics, it will bring great inconvenience to managers due to the inconsistent format. So how to set the excel time format?Today I brought you the setting tutorial of excel time format, and friends who need to unify the time format to 00:00 can come and see the specific operation. Excel Tips
1. Open Excel** to check whether the time is out of order.
2. Select the cell in ** that needs to modify the time format.
3. Click the selected cell and right-click to select ".Format cells
4. In the pop-up dialog box, select ".Customize
5. Enter hh:mm in the Type box.
6. Click ".OKto format it.
Summary
1. Open Excel** to check whether the time is out of order.
2. Select the cell in ** that needs to modify the time format.
3. Click the selected cell, right-click and select "Format Cell".
4. In the pop-up dialog box, select "Custom".
5. Enter hh:mm in the Type box.
6. Click "OK" to set the format.
The above is the tutorial for setting up the Excel time format shared to achieve the unity of time.