How to Convert Time to a Number in Excel

This Excel guide explains how to convert Time to a Number in Excel. Begin by entering =A2*24 to convert an Excel time in A2 to decimal hours, or =A2*1440 for minutes. The next decision comes from the second check: format the result as Number or General so Excel does not display another time.

What You Need Before You Convert Time to a Number in Excel

The scope is defined by the exact Excel account, platform, file location, and control named in the workflow. Keep the test on the affected item, and use the result of the first two checks before changing a broader setting.

The Exact Excel Workflow

Follow these steps in order. If a step changes data, permissions, authentication, or a subscription, record the current state first and keep a recoverable copy or backup method.

1. Enter =A2*24 to convert an Excel time in A2 to decimal hours, or =A2*1440 for minutes.
2. Format the result as Number or General so Excel does not display another time.
3. Use MOD(A2,1) first when the source includes a date and only the time portion is needed.
4. Test midnight, 30 minutes, and a multi-hour value before filling the formula down.

Confirm the Convert Time to a Number in Excel Result

Repeat the original Excel action with the same account, file, and device. A successful result means the reported symptom no longer appears, the intended setting persists after reopening, and no unrelated file, user, or subscription has changed.

Use WPS Office for This Document Workflow

Use Word, Excel, and PPT for FREE

Free Download

WPS Office can perform this local file workflow in WPS Spreadsheets. It opens common Microsoft Office formats in a familiar interface and also provides PDF tools and WPS AI features for drafting, summarizing, formulas, and everyday document work.

1. Open the worksheet in WPS Spreadsheets
2. Multiply the time value by 24 for hours or by 1440 for minutes
3. Apply a Number format instead of a time format
4. Test midnight and multi-hour values before filling the formula down

Excel FAQs About Convert Time to a Number in Excel

Will every Excel user get the same result when trying to convert Time to a Number in Excel?

Not necessarily. The result depends on the account type, file location, app version, permissions, and device involved in this exact workflow.

What details matter before I try to convert Time to a Number in Excel?

Record the exact message, affected account or file, platform, and the result of this first check: Enter =A2*24 to convert an Excel time in A2 to decimal hours, or =A2*1440 for minutes.

What result should I expect after the final step?

The expected result is the one established by the final check: Test midnight, 30 minutes, and a multi-hour value before filling the formula down.

When would this Excel workflow require administrator access?

Administrator access is required only when the named control belongs to tenant policy, billing, authentication, service health, or organization-wide permissions.