Calculate and Round a Percentage of Hours to 30 Minutes in Excel
Question details
Calculate a percentage of available hours and return it as a time value rounded to the nearest 30 minutes.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to calculate a portion of available hours, such as 20% of 56 hours, and display the rounded duration.
- Observed behavior
- The desired result is an elapsed time rounded to a half-hour increment, with durations over 24 hours displayed correctly.
Check whether your hours are entered as a plain number or as an Excel time value. For the main formula, enter the hours as a number such as 56 and the percentage as 20% or 0.2.
Use MROUND to calculate and round hours to 30 minutes
Use this method when the available hours are entered as a plain number and you want an elapsed-time result.
Excel stores time as a fraction of a day. Dividing the hours by 24 converts them to a time value, and 1/48 represents 30 minutes.
Enter 56 in cell A1 and 20% in cell B1.
Select an empty cell and enter =MROUND(A1/24*B1,1/48). Press Enter.
Right-click the result cell and select Format Cells. On the Number tab, select Custom, enter [h]:mm in the Type field, and click OK.

Round a Percentage of Hours in WPS Spreadsheet
Use WPS Spreadsheet to calculate a percentage of available hours, round the duration to the nearest half hour, and display it in an elapsed-time format.
- 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
- 2. Enter the values: Enter the available hours as a number in A1 and the percentage in B1, such as 56 and 20%.
- 3. Enter the formula: Select an empty cell, enter =MROUND(A1/24*B1,1/48), and press Enter.
- 4. Format the result: Right-click the result cell, choose Format Cells, and select Custom on the Number tab. Enter [h]:mm in the Type field and confirm.

Frequently Asked Questions
What formula rounds 20% of 56 hours to the nearest half hour?
Enter =MROUND(56/24*20%,1/48) in a cell, then use Format Cells > Number > Custom and enter [h]:mm. The result displays as 11:00.
Why do I need to divide the hours by 24?
Excel represents one day as 1, so dividing a plain number of hours by 24 converts it to a time value. If A1 already contains an Excel duration, use =MROUND(A1*B1,1/48) instead.
How do I display a result longer than 24 hours?
Right-click the result cell, select Format Cells > Number > Custom, and enter [h]:mm in the Type field. The brackets keep the total hours from wrapping after 24.
What if I cannot find [h]:mm in the custom format list?
In Format Cells, select Custom and type [h]:mm directly into the Type field, then click OK.




