To convert a numeric decimal-hours value to an Excel duration, divide it by 24 and apply an elapsed-time format. If A2 contains 7.75, use =A2/24 and format the result as [h]:mm. It displays 7:45 because three quarters of an hour is 45 minutes.
Choose the direction of conversion
Decimal hours to Excel duration uses division by 24. Excel duration to decimal hours uses multiplication by 24. Reversing those operations is a common reason a timesheet produces extremely large or small numbers. Label the source column with its unit before writing a formula.
| A2: decimal hours | Formula | Elapsed display |
|---|---|---|
| 0.25 | =A2/24 | 0:15 |
| 7.75 | =A2/24 | 7:45 |
| 8.1 | =A2/24 | 8:06 |
| 40.5 | =A2/24 | 40:30 |
Keep the converted result numeric
Apply a number format to the result cell instead of converting the result into display text. A numeric duration can be summed, compared and converted back. A text label may look identical but behaves differently in formulas and exports.
For a whole column, place =A2/24 in B2 and fill down. Sum B2:B6 for the duration total. Independently sum A2:A6 for the decimal total. The duration total multiplied by 24 should match the decimal total before any display rounding.
Decide what happens to fractions of a minute
An input of 7.3333 hours is approximately 7 hours 19 minutes 59.88 seconds. Showing 7:20 hides that small fractional-minute difference; it does not necessarily change the stored value. Use a seconds display when reconciling precision-sensitive data.
If a workflow explicitly requires rounding to the nearest whole minute, calculate =ROUND(A2*60,0)/1440. This is a different operation from merely changing the display. Document the rounding decision and keep the unrounded source column. Rounding each row and rounding only the grand total can produce different totals.
Diagnose unexpected results
First check that A2 is a number and really represents hours. A number exported as minutes needs division by 1440 to become an Excel duration, not division by 24. A text value such as “7.75 hours” must be cleaned before arithmetic. Decimal separators also depend on the workbook's regional settings.
Second, check the destination format. Ordinary h:mm can wrap totals after 24 hours; [h]:mm preserves accumulated hours. Third, check negative values. Some Excel date-system and formatting combinations do not display negative durations as expected. Keep signed adjustments in decimal hours if that is your reconciliation unit.
The time-storage and formatting principles are illustrated in Microsoft's time calculation guidance. The examples above use numeric inputs and arithmetic, not text parsing.
Frequently asked questions
Is 7.30 decimal hours equal to 7 hours 30 minutes?
No. The fraction 0.30 multiplied by 60 is 18 minutes. Seven hours 30 minutes is 7.5 decimal hours.
Should I export the time display or the decimal value?
Use the unit required by the receiving system. A formatted duration and a decimal number are not interchangeable in a CSV import.
Related calculators and guides
- Decimal Hours Calculator & Bulk Timesheet Converter
- Why Decimal Hours Totals Differ After Rounding
- Check a Decimal-Time CSV Before a Payroll Import
Explore more in Hours & Pay Calculators and Guides.