However, the output format of your calculations will be confusing, as it will appear as a number, so you need to convert the format of the output cell to correctly display a time.

If the numbers keep changing to dates in Microsoft Excel, you can use the following methods to fix the issue: Format cells as text. Insert an apostrophe before the number. Use Paste Special.

For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set Excel to display dates in a variety of ways, no matter how you type in the data.

Excel has a surprising limitation that you may not discover until you try to enter more than 15 digits in a cell. The application can only store numbers with15 digits of precision.