How is the date calculated in Excel? You may have been doing something wrong.

Hi, everybody! I'm Yali Zi.

Learn a little Excel every day, work efficiency up~up~

A colleague next to me complained that the date in Excel changed to "#" and it took more than an hour to fix it.

Pear also heard and thought that you might encounter the same problem, so today I would like to share with you an issue on the solution to the Excel time problem (including the date mentioned above becomes "#").

01. Date change "#" the date of Excel becomes "#", which may be due to the following two situations:

The ❶ cell is too small.

Problem with ❷ date format.

If it's ❶, we just need to lengthen the cell a little bit, ↓↓↓.

If it is ❷, we just need to select the cells in column B and select General in the number in the start tab.

02. Merge date and time when we need to merge date and time into one column, we just need to "add".

In this step of operation, there are many partners who are easy to fall into 👇.

▋ error practice:

The method of "&" symbol is used in addition, and the results are as follows:

▋ correct practice:

Direct addition (B2+C2), the results are as follows:

03. Separate the hour and the clock. In Excel, separate the hour from the clock. You can do this with two functions:

In C2 cells, use the HOUR function to extract hours; in D2 cells, use the MINUTE function to extract minutes.

Enter the formula separately:

= HOUR (B2) = MINUTE (B2)

Finally, the drop-down fill is complete.

These are the Excel tips shared today. Have you get arrived yet?

Hurry up and try it with the friends around you.

A little trick every day, the boss will give you a better one!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Yalizi Editor: Yali Zi