How to Convert Time to Decimal in Excel

Excel stores time as a fraction of a 24-hour day — which means that underneath every time value you see on screen, there's a decimal number doing the actual math. Converting time to decimal isn't just a formatting trick; it's often essential for payroll calculations, time tracking, billing, and data analysis where you need to work with hours and minutes as plain numbers.

Why Excel Stores Time as a Decimal

Before touching a formula, it helps to understand what Excel is actually doing. When you enter 12:00 PM, Excel stores it internally as 0.5 — because noon is exactly halfway through a 24-hour day. Midnight is 0, and 11:59 PM is just under 1.

This means:

• 1 hour = 1/24 ≈ 0.04167
• 30 minutes = 1/48 ≈ 0.02083
• 6 hours = 6/24 = 0.25

That underlying decimal is what you're "converting to" — you're just surfacing it in a more usable form.

The Three Most Common Decimal Formats You Might Need

When people say "convert time to decimal," they usually mean one of three things:

Each requires a slightly different approach.

How to Convert Time to Decimal Hours ⏱️

This is the most common conversion — turning something like 2:45 into 2.75 hours.

Method 1: Multiply by 24

Since Excel stores time as a fraction of a day, multiplying by 24 converts it to hours:

=A1*24 

If A1 contains 2:45, this returns 2.75.

Important: After entering the formula, format the result cell as a Number (not Time), or Excel may display the result as a time value instead of a decimal.

Method 2: Use the HOUR, MINUTE, and SECOND functions

If you want more control — or your data isn't formatted as a time value — you can build the decimal manually:

=HOUR(A1) + MINUTE(A1)/60 + SECOND(A1)/3600 

This extracts each component and adds them together as fractional hours. It's more verbose but easier to audit in complex spreadsheets.

How to Convert Time to Decimal Minutes

Multiply by the number of minutes in a day (1440):

=A1*1440 

2:30 becomes 150 minutes. Same formatting rule applies — make sure the output cell is formatted as a Number.

How to Convert Time to Decimal Seconds

Multiply by the number of seconds in a day (86400):

=A1*86400 

0:01:30 (one minute, thirty seconds) becomes 90.

Handling Duration vs. Clock Time

There's an important distinction that catches a lot of people out: clock time (a specific time of day) and duration (an elapsed period) behave differently.

• Clock time like 9:00 AM is stored as a fraction of the current day.
• Duration like 25 hours goes over 1.0 in Excel's decimal system — 25:00 is stored as approximately 1.0417.

If you're tracking hours worked across multiple days, Excel may display times over 24 hours incorrectly unless you format the cells as [h]:mm rather than h:mm. The square brackets tell Excel not to reset after 24 hours. This affects what you see — but the underlying decimal math still works the same way with *24.

Dealing with Text-Formatted Time Values 🔧

Sometimes time data imported from external sources — CSVs, databases, or other apps — arrives as text strings rather than real Excel time values. A cell showing "2:30" formatted as text won't calculate correctly.

You can convert text to a usable time value first using:

=TIMEVALUE("2:30") 

Or, if the text is in a cell:

=TIMEVALUE(A1)*24 

This parses the text string into Excel's internal time format and then converts it to decimal hours in one step.

If you're dealing with inconsistent formats — some cells with seconds, some without — you may need to combine TIMEVALUE with text-cleaning functions like TRIM or SUBSTITUTE to standardize the format before conversion.

Formatting the Output Cell

The formula is only half the job. Excel will sometimes "helpfully" reformat a decimal result back into a time display, especially if the source cell is time-formatted. To lock in your decimal result:

1. Select the result cell(s)
2. Press Ctrl+1 to open Format Cells
3. Choose Number under the Number tab
4. Set the decimal places you want (typically 2–4 for time-based work)

Without this step, 2.75 might display as 6:00 AM, which is technically the same underlying value interpreted as a time — just not what you're after.

Variables That Affect Which Approach Works for You

The "right" method depends on a few factors that vary by situation:

• Data source: Is your time data entered manually, imported from a system, or generated by a formula? Imported data is more likely to arrive as text.
• What you're calculating: Payroll often needs decimal hours; scientific data might need seconds; project management tools often import or export in minutes.
• Duration vs. clock time: Spreadsheets tracking shifts, timers, or cumulative hours behave differently from those tracking appointment times.
• Excel version: The core functions (HOUR, MINUTE, SECOND, TIMEVALUE) are consistent across versions, but some newer dynamic array behaviors in Excel 365 can affect how formulas propagate across ranges.
• Regional settings: Date and time separators vary by locale, which can affect how Excel parses entered or imported values.

Someone managing payroll for hourly workers needs a clean, auditable decimal-hours column with consistent formatting across hundreds of rows. Someone doing a quick one-off calculation in a personal spreadsheet can get away with a single cell formula and manual formatting. The math is the same — the setup around it isn't.