Excel Convert Hours and Minutes to Decimal

Converting hours and minutes to decimal format in Excel is a common task for accurate time tracking, payroll calculations, and project management. This step-by-step guide will help you perform these conversions efficiently using simple formulas.

Step-by-Step Conversion in Excel

  1. Enter Your Data: Input hours in one cell and minutes in another. For example, hours in A2 and minutes in B2.
  2. Apply the Formula: In cell C2, enter:

    =A2 + (B2 / 60)

  3. Format the Cell: Ensure that cell C2 is formatted to display numbers with two decimal places.
  4. Drag the Formula: If you have multiple rows, drag the fill handle from C2 down to apply the formula to other rows.

Example

Hours Minutes Decimal Hours
2 30 2.50
1 45 1.75
3 15 3.25

Visual Guide

Excel Conversion Guide

Related Tools: