Technology Software

How to Change Hours to Tenths in Excel

    • 1). Type the number of hours and minutes into a cell. For example, type "7:30" into cell "A1."

    • 2). Type "=A1*24" into a blank cell in Excel, where "A1" is the actual cell address you typed your hours and minutes into. In this example, leave the cell address as "A1."

    • 3). Press the "Enter" key. Excel converts the hours and minutes to hours and tenths.

Leave a reply