How to Convert Hours to Decimal in Excel: Formulas & Full Guide

How to Convert Hours and Minutes to Decimal in Excel

To successfully convert time in Excel, you must first recognize whether your time entries are stored as true Excel time values (serial numbers) or as text strings. Here is how to solve both scenarios:

Scenario 1: Converting True Excel Time Serial Values (=A2*24)

In Excel's internal architecture, 1 whole day equals the integer 1.0. Therefore, one hour equals 1 ÷ 24 = 0.041667, and 12 hours equals 0.5. When you type 8:30 into cell A2, Excel stores the decimal value 0.354167.

Because there are 24 hours in a day, multiplying that fractional serial number by 24 scales it into decimal hours.

Step-by-Step Instructions:

1. Locate your time cell: Assume your time duration (e.g., 07:45) is in cell A2.
2. Enter the multiplication formula: In cell B2, type:
   =A2 * 24
3. Fix the formatting glitch: Excel will usually display 12:00 AM or another time format by default. Select cell B2, navigate to the Home tab on the Excel ribbon, click the Number Format dropdown, and choose Number (set to 2 decimal places).
4. Inspect the result: Cell B2 will now display 7.75.
5. Calculate total pay: In cell C2, multiply decimal hours by the hourly rate (e.g., =B2 * 25.00) to get the correct wage of $193.75.

Scenario 2: Converting Times Entered as Text or Manual Numbers

If your time data was exported from third-party time clock software or entered manually as text (e.g., "8:30" formatted as Text, or where hours and minutes are in separate columns), multiplying by 24 may produce a #VALUE! error.

In this situation, use Excel's built-in time extraction functions (see Microsoft's HOUR function documentation) to isolate each unit:

This formula works reliably regardless of whether the cell is recognized as a time serial or a standard timestamp. For 08:45:00, HOUR(A2) returns 8, andMINUTE(A2)/60 returns 0.75, summing to 8.75 decimal hours.

How to Convert Hours and Minutes to Decimal

Whether you are working in Microsoft Excel, Google Sheets, LibreOffice Calc, or on paper, the core logic of converting hours and minutes to decimal remains constant:

Follow these three universal rules whenever converting times:

• Rule 1 (Keep whole hours whole): The hour figure remains unchanged to the left of the decimal point.
• Rule 2 (Divide minutes by 60): Minutes are fractions of 60, not 100. Divide the minutes by 60 to calculate the decimal fraction.
• Rule 3 (Round to two decimal places): For financial accounting, round the final decimal hour to two decimal places (hundredths) to match standard billing practices.

You can also cross-reference your spreadsheet formulas against our printable 60-minute conversion chart.

Advanced Excel Timesheet Formulas: Summing Over 24 Hours & Rounding

When building automated payroll templates in Excel, two common edge cases frequently cause headaches:

1. Weekly Totals Exceeding 24 Hours ([h]:mm Format)

If you sum a weekly column of times (such as =SUM(A2:A6)) and total hours exceed 24, Excel automatically resets its internal clock to 0:00 every 24 hours. A 42-hour workweek will appear as 18:00 (42 - 24 = 18).

The Solution: Right-click the total cell, choose Format Cells, select Custom, and type [h]:mm into the Type box (details in the Excel custom number formatting guide). The square brackets tell Excel to display cumulative hours past 24 rather than rolling over to a new day. Then apply =A7*24 to get 42.00 decimal hours.

2. Rounding Decimal Hours to Prevent Penny Discrepancies

Recurring decimals like 20 minutes (0.333333...) can introduce fractional penny rounding errors when multiplied across dozens of employees. Wrap your conversion formula in Excel's ROUNDfunction (per Excel's ROUND function reference) to lock the decimal value:

This guarantees that your formulas calculate from the exact displayed two-decimal figure.

Excel Time-to-Decimal Formula Reference: 5 Common Scenarios

Different Excel scenarios need different formulas. Use this table to find the right approach for your timesheet setup:

Cross-check any formula result against the manual calculation using our hours-to-decimal converter or reverse the result with our decimal-to-hours converter.

How to Convert Hours to Decimal in Google Sheets

Google Sheets uses the same day-fraction time model as Excel, so the core formula is identical: multiply the time cell by 24. The main difference is in how you fix the number format afterward.

Standard Method: =A2*24

1. Enter your time (e.g., 8:30) in cell A2. Sheets will auto-detect it as a time value.
2. In cell B2, type:
   =A2*24
3. Fix the format: By default Sheets may show a time result. Select B2, go to Format → Number → Number to display the decimal correctly.
4. Result: Cell B2 shows 8.5 for 8 hours 30 minutes.

Google Sheets vs. Excel: Key Differences

• No [h]:mm custom format needed: In Google Sheets, you can use Format → Number → Duration to display cumulative hours over 24 without needing the bracket notation.
• GOOGLEFINANCE functions: Sheets doesn't support Excel's SECOND() function in the same way for imported data — use =HOUR(A2)+(MINUTE(A2)/60) as a safer cross-platform formula.
• ARRAYFORMULA support: To apply the conversion across an entire column at once: =ARRAYFORMULA(IF(A2:A<>"", A2:A*24, "")).

For the full list of Google Sheets time functions, see the Google Sheets function list.