Calculation Issues

Why Excel Displays 8.25 as 06:00 and How to Fix It

John Wilson Sep 30, 2026 869 views

Question details

The user needs to understand why converting a decimal number like 8.25 into a time format results in 06:00, and how to correctly display decimal hours as standard time.

Why Excel Displays 8.25 as 06:00 and How to Fix It

Product: Excel
Device & OS: not provided
Scenario: Formatting raw decimal numbers that represent total hours into a readable hours and minutes (hh:mm) format.
Observed behavior: When the value 8.25 is formatted as hh:mm, Excel displays it as 06:00 instead of 08:15.

Before you start

Before applying a fix, confirm whether your raw numerical data is meant to represent total hours, total minutes, or total days, as spreadsheets calculate time based on fractions of a 24-hour day.

Solution 1Recommended

Convert Decimal Hours to Time by Dividing by 24

Since Excel interprets whole numbers as days, you must divide your decimal hours by 24 to convert them into a valid time serial number before applying the time format.

Excel stores dates and times as serial numbers where 1 equals one full day (24 hours). Therefore, entering 8.25 tells Excel you mean 8 days and 0.25 of a day. Because 0.25 of a day equals exactly 6 hours, Excel displays 06:00 when you apply the hh:mm format, ignoring the 8 whole days.

Select a blank cell

Click on an empty cell adjacent to the cell containing your decimal value (for example, if 8.25 is in cell A1, select B1).

Apply the division formula

Type the formula =A1/24 into the selected cell and press Enter. This converts the decimal hours into a daily fraction.

Format the result as Time

Right-click the cell with the formula, select 'Format Cells', go to the 'Number' tab, select 'Custom', type hh:mm in the Type field, and click OK. The cell will now correctly display 08:15.

Convert Decimal Hours to Time by Dividing by 24

Displaying hours over 24: If your resulting time exceeds 24 hours, apply the custom format [h]:mm instead of hh:mm so Excel does not reset the hour count to zero.

Easily Convert and Format Time Values in WPS Spreadsheet

WPS Spreadsheet handles time and date serial numbers exactly like Microsoft Excel, ensuring your formulas and formatting work flawlessly without any learning curve.

1. Open your data file: Launch WPS Spreadsheet and open the document containing your decimal values.
2. Enter the conversion formula: Select a new cell and input =A1/24 (assuming A1 has your decimal) to convert it to a time fraction.
3. Open Format Cells: Press Ctrl+1 on your keyboard to quickly open the Format Cells dialog box.
4. Apply custom time formatting: Navigate to the 'Custom' category, type hh:mm, and click OK to display the time correctly.

100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Identical time and date serial number calculationsIntuitive cell formatting dialog for custom time displaysFree and lightweight alternative for daily data analysis

microsoft office alternative - wps office

Frequently Asked Questions

Why does 8.25 become 06:00 in Excel?

Excel calculates time in days. The number 8.25 represents 8 full days plus 0.25 (a quarter) of a day. Since one quarter of a 24-hour day is 6 hours, applying a time format will only display the remainder time, which is 06:00.

How do I convert a time format back into a decimal number?

To reverse the process and convert a time value (like 08:15) back into a decimal number of hours (8.25), multiply the cell containing the time by 24 (e.g., =A1*24). Then, change the format of the resulting cell from 'Time' to 'General' or 'Number'.

How do I display time that goes over 24 hours?

By default, the standard hh:mm format resets after 24 hours. To display cumulative time (like 36:30), you must wrap the hour indicator in square brackets in the Format Cells dialog. Use the custom format [h]:mm.

Excel & Data Problems