Calculation Issues

Calculate and Round a Percentage of Hours to 30 Minutes in Excel

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

Calculate a percentage of available hours and return it as a time value rounded to the nearest 30 minutes.

Calculate a Percentage of Hours Rounded to 30 Minutes in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the inputs

Enter 56 in cell A1 and 20% in cell B1.

2
Calculate the rounded duration

Select an empty cell and enter =MROUND(A1/24*B1,1/48). Press Enter.

3
Apply an elapsed-time format

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.

Use MROUND to calculate and round hours to 30 minutes
Example result: Twenty percent of 56 hours is 11 hours and 12 minutes, which rounds to 11:00 at the nearest 30 minutes.
WPS Spreadsheet

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. 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
  2. 2. Enter the values: Enter the available hours as a number in A1 and the percentage in B1, such as 56 and 20%.
  3. 3. Enter the formula: Select an empty cell, enter =MROUND(A1/24*B1,1/48), and press Enter.
  4. 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.
Round calculated durations to 30-minute increments with MROUNDDisplay durations over 24 hours using a custom time formatOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and cell formatting tools
microsoft office alternative - wps office

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.