Chart & Visualization Issues

Calculate Hours and Minutes Correctly for Excel Doughnut Charts

Nimra Malik Oct 10, 2026 869 views

Question details

The user needs to accurately display total hours and minutes as a percentage in an Excel doughnut chart, but the time values are appearing as small fractions instead of correct hour totals.

How to Calculate Hours and Minutes Correctly for an Excel Doughnut Chart

Product: Excel
Device & OS: not provided
Scenario: Creating a doughnut chart to visualize progress against a time-based goal, such as reaching a 1,000-hour target.
Observed behavior: Time formatted as [h]:mm displays as a small fraction in charts and percentage calculations because the software stores time as a fraction of a 24-hour day.

Before you start

Ensure your source data cells containing the hours and minutes are properly formatted using the custom format [h]:mm so the program recognizes them as cumulative time values.

Solution 1Recommended

Convert the Time Value to Hours by Multiplying by 24

To calculate true hours for a chart or percentage, you must convert the time fraction to whole hours by multiplying the cell reference by 24.

Because spreadsheet software stores time as a fraction of a 24-hour day, 12 hours is internally stored as 0.5, and 1,000 hours is stored as 41.66. If you use these raw numbers directly in a doughnut chart, your percentages will be wildly inaccurate.

By multiplying the time value by 24, you convert the underlying fraction into the exact number of hours, allowing you to accurately calculate percentages against a target.

Select the target cell

Select the empty cell where you want to calculate the percentage for your doughnut chart (e.g., progress toward a 1,000-hour goal).

Enter the conversion formula

Type the formula to multiply the time value by 24 and divide by your goal. For example, enter =Log!B64*24/1000 if your time value is in cell B64 on the Log sheet.

Format as a percentage

Right-click the result cell, select 'Format Cells', and choose 'Percentage' or 'Number' to display the correct progress (e.g., 100% instead of a small decimal).

Update the doughnut chart

Select this newly calculated percentage data, go to the 'Insert' tab, and create or update your doughnut chart to reflect the accurate visualization.

Convert the Time Value to Hours by Multiplying by 24

Chart Accuracy Guaranteed: Converting the fraction to a whole number ensures your doughnut chart accurately visualizes your time-based goals without skewing the data.

Easy Data Visualization with WPS Office

Create and Format Doughnut Charts Effortlessly in WPS Spreadsheet

WPS Spreadsheet offers seamless time formatting, advanced charting tools, and full compatibility with Excel files. Visualizing hour and minute trackers is straightforward and highly intuitive.

1. Open your workbook: Launch WPS Spreadsheet and open your time-tracking workbook.
2. Apply the time conversion formula: Use the =Cell*24/Goal formula to calculate the exact hour percentages accurately.
3. Insert the chart: Select your calculated data, go to the 'Insert' tab on the top ribbon, and click the 'Chart' icon.
4. Select Doughnut type: Choose 'Doughnut' from the available chart types and use the right-side panel to customize your colors, data labels, and chart title.

Fully compatible with Microsoft Excel formulas and time formatsIntuitive interface for creating beautiful Doughnut and Pie chartsFree built-in chart customization options for professional reportsLightweight application that runs smoothly on any device

Frequently Asked Questions

Why does 24 hours appear as 1.0 in Excel?

Spreadsheet applications track dates and times as serial numbers, where the number 1 represents a full 24-hour day. Therefore, 12 hours is stored as 0.5, and 24 hours equals exactly 1.0 in the internal numeric system.

How do I format a cell to show total hours greater than 24?

Right-click the cell, select 'Format Cells', go to the 'Custom' category, and enter [h]:mm. The square brackets around the 'h' tell the program to display cumulative elapsed time past 24 hours rather than resetting like a 24-hour clock.

Why is my Doughnut chart not showing percentages correctly?

Doughnut charts plot the exact underlying numeric values of the cells. If your cell contains a time value formatted as a date/time fraction rather than a converted percentage, the chart will plot the small fractional number (e.g., 41.6 instead of 1000). Always convert your time values to standard numbers or percentages by multiplying by 24 before charting.

Excel & Data Problems