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.

In Microsoft Excel, you can convert a number into a fraction using the Fraction format. Learn how to display Numbers as Fractions in Excel.

Learn how to format numbers in Thousands, Millions, and Billions in Excel and Google Sheets. Use number Formatting to convert numbers.

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.