Skip to content
Date and Time

Excel Time Calculator

Excel Time Calculator

Convert between Excel’s decimal time values and HH:MM:SS, or add two durations together.

days

In Excel, 0.5 = 12:00 PM and 1.0 = a full 24-hour day.

If you have ever copied a time value out of Excel and pasted it somewhere else, you may have seen something strange: instead of 2:30 PM, the cell showed 0.6041666667. That number is not an error. Excel stores dates and times as plain numbers, where one whole day equals 1.0. Under that system, 12:00 noon is 0.5, 6:00 PM is 0.75, and a full 24-hour day is exactly 1.0. It is an elegant system inside a spreadsheet, but the moment you need to read, check, or reuse those numbers anywhere outside Excel, you have to convert them back into hours, minutes, and seconds — and that is exactly what this Excel Time Calculator does.

This calculator works in both directions. Give it an Excel decimal value like 0.5 and it returns 12:00:00. Give it a clock time like 13:45:30 and it returns the Excel decimal 0.5732638889. It also converts plain decimal hours into clock time (2.5 hours becomes 02:30:00), converts clock times into decimal hours for payroll and billing, and adds two durations together, which is handy for totaling timesheets, shift lengths, or project hours. The sections below explain each conversion, show the exact math with fully worked examples, and answer the questions people ask most often about Excel time values.

What the Excel Time Calculator Does

The calculator offers five conversion modes, selectable from the dropdown at the top. The first mode converts an Excel decimal time value — a fraction of a day — into HH:MM:SS format. This is the mode you need when a spreadsheet, a database export, or an API hands you a raw number like 0.3541666667 and you want to know what time of day it represents. The second mode does the reverse: it takes a time written as HH:MM:SS and returns the Excel decimal, which is useful when you need to feed a proper Excel time value into a formula or a system that expects one.

The third and fourth modes deal with decimal hours, which are different from Excel decimals and are a constant source of confusion. Decimal hours measure a duration in hours — 2.5 hours means two and a half hours — while an Excel decimal measures a fraction of a day, where 0.5 means twelve hours. Mode three converts decimal hours to HH:MM:SS, and mode four converts HH:MM:SS to decimal hours. The fifth mode simply adds two durations, each entered as HH:MM:SS, and returns the total. Totals are allowed to exceed 24 hours, so adding an overnight shift like 22:15:00 plus 03:30:00 correctly gives 25:45:00 rather than wrapping around to 01:45:00.

How to Use the Excel Time Calculator

Start by choosing the conversion type from the dropdown menu. The label, placeholder, and hint text under the input box update automatically to show you what to enter. For the two Excel-decimal modes, enter a plain number such as 0.5 or 1.75. For the time-based modes, enter the time in hours, minutes, and seconds separated by colons, for example 13:45:30; you may leave off the seconds and write 6:05 if you prefer, and the calculator treats it as 6:05:00. In add mode, a second input box appears for the second duration.

Press Calculate to see the result, which appears in a green result panel with each step of the conversion labeled. If something is wrong with your input — a negative number, letters where a time should be, or minutes larger than 59 — a red message explains the problem instead of guessing. Press Reset at any time to clear the form and start over.

The Formula Behind the Calculator

Every conversion in this calculator rests on a single fact: one day contains exactly 86,400 seconds (24 hours × 60 minutes × 60 seconds). To turn an Excel decimal value into a clock time, multiply it by 86,400 to get the total number of seconds, then split that total into hours, minutes, and seconds. The hours are the whole number of times 3,600 fits into the total, the minutes are what remains divided by 60, and the seconds are the final remainder. Going the other direction, convert a clock time into its total seconds first — hours × 3,600 plus minutes × 60 plus seconds — and then divide by 86,400 to get the Excel decimal.

Decimal hours use 3,600 instead of 86,400, because one hour contains 3,600 seconds. Decimal hours to clock time means multiplying by 3,600 and splitting into HH:MM:SS; clock time to decimal hours means dividing the total seconds by 3,600. Adding two durations is the simplest operation of all: convert both to total seconds, add them, and format the sum as HH:MM:SS. Because the total is never wrapped at 24 hours, sums like 25:45:00 display exactly as they should.

Worked Examples With Full Arithmetic

Example 1 — Excel decimal to clock time. Convert 0.5. Multiply by 86,400: 0.5 × 86,400 = 43,200 seconds. Divide into hours: 43,200 ÷ 3,600 = 12 hours exactly, with 0 minutes and 0 seconds left over. Result: 12:00:00, which is 12:00 noon. This is the single most useful Excel time fact to memorize: one half of a day is midday.

Example 2 — a less obvious decimal. Convert 0.3541666667. Multiply: 0.3541666667 × 86,400 = 30,600 seconds (rounded to the nearest second). Split into hours: 30,600 ÷ 3,600 = 8.5 hours, so 8 full hours use up 28,800 seconds, leaving 1,800 seconds. Convert the remainder: 1,800 ÷ 60 = 30 minutes exactly, with 0 seconds left. Result: 08:30:00. Whenever you see a repeating decimal like this one, it usually corresponds to a clean half-hour or quarter-hour mark.

Example 3 — a value larger than one day. Convert 1.5. Multiply: 1.5 × 86,400 = 129,600 seconds. Divide: 129,600 ÷ 3,600 = 36 hours exactly. Result: 36:00:00. Note that the calculator shows the total as 36 hours rather than wrapping it to 12:00:00. In a real spreadsheet, Excel would display 1.5 as one full day plus 12:00 PM; the calculator keeps it simple and reports the straight total, which is what you want when adding up durations.

Example 4 — clock time to Excel decimal. Convert 13:45:30. First find the total seconds: 13 × 3,600 = 46,800; 45 × 60 = 2,700; plus 30 seconds gives 49,530 seconds. Divide by 86,400: 49,530 ÷ 86,400 = 0.5732638889. Result: 0.5732638889. If you type this value into Excel and format the cell as a time, it displays 1:45:30 PM.

Example 5 — decimal hours to clock time. Convert 2.5 hours. Multiply by 3,600: 2.5 × 3,600 = 9,000 seconds. Split: 9,000 ÷ 3,600 = 2.5, so 2 full hours use 7,200 seconds, leaving 1,800 seconds, which is exactly 30 minutes. Result: 02:30:00. Compare this with Example 1: 0.5 as an Excel decimal means 12 hours, but 0.5 as decimal hours means 30 minutes. The units change everything.

Example 6 — clock time to decimal hours. Convert 06:30:00. Total seconds: 6 × 3,600 = 21,600, plus 30 × 60 = 1,800, for a total of 23,400 seconds. Divide by 3,600: 23,400 ÷ 3,600 = 6.5. Result: 6.5 hours. Payroll systems love this format because multiplying 6.5 by an hourly rate is trivial, while multiplying 06:30:00 by a rate is not.

Example 7 — adding two durations. Add 08:30:00 and 02:45:00. Convert each to seconds: 08:30:00 = 8 × 3,600 + 30 × 60 = 28,800 + 1,800 = 30,600 seconds; 02:45:00 = 2 × 3,600 + 45 × 60 = 7,200 + 2,700 = 9,900 seconds. Add: 30,600 + 9,900 = 40,500 seconds. Split back: 40,500 ÷ 3,600 = 11.25 hours, so 11 full hours use 39,600 seconds, leaving 900 seconds = 15 minutes. Result: 11:15:00.

Example 8 — adding across midnight. Add 22:15:00 and 03:30:00. In seconds: 22:15:00 = 79,200 + 900 = 80,100; 03:30:00 = 10,800 + 1,800 = 12,600. Sum: 80,100 + 12,600 = 92,700 seconds. Split: 92,700 ÷ 3,600 = 25.75 hours, so 25 full hours use 90,000 seconds, leaving 2,700 seconds = 45 minutes. Result: 25:45:00. An overnight shift of this shape is exactly why the calculator never wraps totals at 24 hours.

Understanding Your Results

The result panel always shows both sides of the conversion: what you entered and what it became. When you convert a clock time to an Excel decimal, the value is shown with up to ten decimal places, and trailing zeros are trimmed, so a clean value like 0.5 displays as 0.5 rather than 0.5000000000. When you convert a clock time to decimal hours, up to six decimal places are shown, which is more than enough for payroll math — one second is only about 0.000278 hours.

Conversions into HH:MM:SS are rounded to the nearest whole second, because clock displays do not show fractions of a second. If your Excel decimal has more precision than a second can represent, the tiny leftover fraction disappears in the rounding, which is why 0.3541666667 and 0.3541666666 can both legitimately display as 08:30:00. Hours in the output are not limited to two digits: totals of 36:00:00 or 101:15:00 are valid and intentional.

Common Mistakes to Avoid

The most expensive mistake is mixing up decimal hours and Excel decimals. If a timesheet says an employee worked 0.5 and you pay them for half an hour, but the 0.5 was an Excel decimal meaning 12 hours, the paycheck will be very wrong. Always confirm which unit a number is in before converting: Excel decimals are fractions of a day, decimal hours are a count of hours.

Next, respect the ranges of minutes and seconds. A value like 1:75 is not a valid time — minutes and seconds must each be between 00 and 59 — and the calculator will reject it rather than guess what you meant. Hours, on the other hand, can be any non-negative whole number, including values above 24. Negative time values are also rejected, because Excel itself cannot display negative times in its default date system and shows them as a row of hash marks instead.

Finally, remember that changing a cell's format in Excel does not change the number stored in it. Typing 0.5 and formatting the cell as time shows 12:00 PM, but the cell still contains 0.5, and any formula reading that cell sees 0.5. Conversions like the ones in this calculator describe the stored value, not the display format.

Frequently Asked Questions

1. What exactly is Excel time?

Excel time is the way Microsoft Excel stores times internally: as a decimal fraction of a 24-hour day. Midnight is 0.0, 6:00 AM is 0.25, noon is 0.5, 6:00 PM is 0.75, and the moment before midnight is 0.99999. Dates are stored the same way, with whole numbers counting the days since the start of Excel's calendar, so a value like 45658.5 means noon on a specific date.

2. Why does 0.5 equal 12:00 PM in Excel?

Because 0.5 is exactly half of one full day. Half of 24 hours is 12 hours, and 12 hours after midnight is 12:00 noon. The math is 0.5 × 24 = 12 hours, or in seconds, 0.5 × 86,400 = 43,200 seconds, which is precisely 12 hours.

3. What is the difference between decimal hours and an Excel decimal?

Decimal hours count hours directly: 2.5 decimal hours means two and a half hours, or 150 minutes. An Excel decimal counts fractions of a day: 0.5 Excel time means half a day, or 12 hours. To convert between them, multiply an Excel decimal by 24 to get decimal hours, or divide decimal hours by 24 to get the Excel decimal.

4. How do I convert 90 minutes to an Excel time value?

Ninety minutes is 5,400 seconds. Divide by 86,400 seconds per day: 5,400 ÷ 86,400 = 0.0625. So 90 minutes is 0.0625 in Excel time. Using the calculator, enter 01:30:00 in the HH:MM:SS to Excel decimal mode to get the same answer.

5. Can the calculator handle times longer than 24 hours?

Yes. Excel decimals larger than 1.0 convert to totals like 36:00:00, and the add mode never wraps around at midnight. A sum of 25:45:00 stays 25:45:00. This makes the calculator suitable for totaling weekly hours and multi-day durations.

6. Why does the Excel decimal show so many decimal places?

Because a single second is a tiny fraction of a day: 1 ÷ 86,400 is approximately 0.0000115741. To represent a time accurately to the second, the decimal needs about ten digits. The calculator trims trailing zeros, so clean values like 0.5 display compactly while precise values keep the digits they need.

7. How should I type the time — does it need seconds?

Seconds are optional. Both 13:45:30 and 13:45 are accepted; the shorter form is treated as 13:45:00. Hours can be one or more digits, so 6:05 works the same as 06:05:00. Minutes and seconds must each be between 00 and 59.

8. Can I add more than two durations at once?

The calculator adds two durations per calculation, but you can chain results: add the first two, then add the third duration to that total, and so on. For a full week of timesheet entries, repeat the addition with the running total until every entry is included.

9. Why does Excel sometimes show ##### instead of a time?

The hash marks appear when a cell contains a negative time value or a date-time that is too wide for the column. Excel cannot display negative times in its standard date system, which is also why this calculator rejects negative inputs rather than producing a result Excel could never show.

10. Is 0.0416666667 really equal to one hour?

Yes. One hour is 1/24 of a day, and 1 ÷ 24 = 0.0416666667. Multiply back to check: 0.0416666667 × 86,400 = 3,600 seconds, which is exactly one hour. Similarly, one minute is 1/1,440 of a day, or about 0.0006944444.

11. Does this match Excel's HOUR, MINUTE, and SECOND functions?

Conceptually, yes. Excel's HOUR function extracts the whole hours from a time value, which is the same as the hours part of the HH:MM:SS this calculator produces. If the calculator converts 0.5732638889 to 13:45:30, then Excel's HOUR, MINUTE, and SECOND functions applied to 0.5732638889 return 13, 45, and 30.

12. Can I use decimal hours for payroll calculations?

That is one of the most common uses. Convert each shift's clock time to decimal hours with the calculator, add the decimal hours together, and multiply by the hourly rate. For example, 06:30:00 becomes 6.5 hours, and at $20 per hour the pay is 6.5 × 20 = $130.00.

13. What happens if I enter a negative Excel decimal?

The calculator shows an error message asking for a value of 0 or greater. Negative time values have no standard clock-time representation in Excel's default system, so rejecting them keeps the results meaningful.

14. How precise are the conversions?

Conversions to HH:MM:SS are rounded to the nearest whole second, which matches how clocks display time. Conversions to decimals keep up to ten decimal places, far more precision than any real-world schedule needs — ten decimal places of a day is less than a hundredth of a second.

15. Can I convert a full date and time, like January 5 at 3:30 PM?

This calculator handles the time-of-day portion only. In Excel, the date part is the whole number and the time part is the fraction, so for a value like 45658.6458 you would convert the fractional part 0.6458 with this calculator — it equals 15:30:00, or 3:30 PM — and leave the whole number 45658 to Excel's date formatting.

Final Thoughts

Excel's decimal time system feels cryptic the first time you encounter it, but it is just a fraction of a day, and every conversion is one multiplication or division away. Whether you are reading an exported report, preparing values for a spreadsheet formula, converting shifts to payroll hours, or adding up project time, this Excel Time Calculator removes the mental arithmetic and the risk of mixing up decimal hours with fractions of a day. Bookmark it next to your timesheet and you will never have to wonder what 0.6041666667 means again.