How Many Seconds Are in a Day? Full Breakdown, Formulas and Excel Method

shape
shape
shape
shape
shape
shape
shape
shape
How Many Seconds Are in a Day? Full Breakdown, Formulas and Excel Method - featured image

There are 86,400 seconds in one day. This comes from multiplying 24 hours by 60 minutes by 60 seconds. It is a number that appears in time tracking, programming, science, payroll and everyday curiosity, so it is worth knowing how it is built and how to use it. This guide gives the answer and the math, then shows the number of seconds in an hour, a week, a month and a year, explains leap years and the difference between a calendar day and a solar day, shows how to convert seconds to hours, minutes and days by hand and in Excel, and gives practice problems with answers that you can check yourself.

Updated November 2026

In this guide

  1. The short answer
  2. Seconds in common time units
  3. Seconds in a month
  4. Seconds in a leap year
  5. Calendar day versus solar day
  6. How to convert seconds to days
  7. How to convert seconds to hours, minutes and seconds
  8. Excel formulas for seconds
  9. Worked example: a work shift
  10. Worked example: how long is 100,000 seconds?
  11. Seconds in programming
  12. Fun facts
  13. Seconds in half a day and other fractions
  14. A quick table of days to seconds
  15. Time tracking and payroll use
  16. Common mistakes
  17. Practice problems
  18. Quick recap

The short answer

One day has 24 hours. Each hour has 60 minutes, and each minute has 60 seconds. So one day has 24 times 60 times 60 seconds, which is 86,400 seconds. It also has 1,440 minutes, since 24 times 60 is 1,440, and 86,400,000 milliseconds. These are the numbers that computers and spreadsheets use when they work with time.

Minutes To Hours Converter screenshot used in the guide: How Many Seconds Are in a Day? Full Breakdown, Formulas and Excel Method
Check your answer with our free Minutes To Hours Converter.

Seconds in common time units

This table lists the number of seconds in the units that people use most.

Time unitSeconds
1 minute60
1 hour3,600
1 day86,400
1 week604,800
1 common year (365 days)31,536,000
1 leap year (366 days)31,622,400

The week figure is 7 times 86,400, and the year is 365 times 86,400. Check our hours in a week guide and our weeks in a year guide for the matching figures in hours and weeks.

Seconds in a month

Months have different lengths, so their number of seconds varies. A 30 day month has 2,592,000 seconds. A 31 day month has 2,678,400 seconds. February has 2,419,200 seconds in a common year with 28 days, and 2,505,600 seconds in a leap year with 29 days. If you need an average, a year of 365 days divided by 12 gives about 30.4 days, which is about 2,628,000 seconds.

Seconds in a leap year

A leap year has 366 days, so it has 31,622,400 seconds, which is 86,400 more than a common year. Leap years occur every four years, except for century years that are not divisible by 400. The year 2000 was a leap year, and 1900 was not. The year 2028 will be the next leap year after 2024. For a long period of ten years with two or three leap days, count the days first and then multiply by 86,400. For 3,652 days, the result is 315,532,800 seconds.

Calendar day versus solar day

For daily life, a day has 86,400 seconds. Astronomers define the solar day as the time between two noons, which is very close to this value but varies a little through the year. Atomic clocks define the second precisely, and occasionally a leap second has been added to keep clocks in step with the rotation of the Earth. Most software ignores leap seconds and treats every day as exactly 86,400 seconds, which is the right choice for almost all business work.

How to convert seconds to days

Divide the number of seconds by 86,400. For 172,800 seconds, the result is 2 days. To convert days to seconds, multiply by 86,400, so 5 days is 432,000 seconds. For a quick estimate, remember that 100,000 seconds is a little more than one day, since 100,000 divided by 86,400 is about 1.157 days, or 1 day and 3 hours with some minutes left over.

How to convert seconds to hours, minutes and seconds

Divide by 3,600 to get whole hours, take the remainder and divide by 60 to get minutes, and what remains is seconds. Take 12,345 seconds. Divided by 3,600 it gives 3 whole hours, with 1,545 seconds left. Divided by 60 this gives 25 minutes, with 45 seconds left. So 12,345 seconds is 3 hours, 25 minutes and 45 seconds, or 3:25:45.

Excel formulas for seconds

Excel stores time as a fraction of a day, so one second is 1 divided by 86,400. To convert seconds in A2 into an Excel time, use =A2/86400 and format the cell as [h]:mm:ss. For 12,345 seconds it shows 3:25:45. To get only the hours as a number, use =A2/3600, which gives 3.4292 for 12,345. For whole hours and minutes use =INT(A2/3600) and =INT(MOD(A2,3600)/60), and for the remaining seconds =MOD(A2,60). To go the other way, convert a time in B2 to seconds with =B2*86400. Our minutes to hours converter works with the same idea.

Worked example: a work shift

An 8 hour shift has 8 times 3,600, which is 28,800 seconds. A 40 hour work week has 40 times 3,600, which is 144,000 seconds. If a machine produces one item every 12 seconds, it can make 28,800 divided by 12, which is 2,400 items in one 8 hour shift. These numbers are used in production planning and in call center reports, where handle times are measured in seconds.

Worked example: how long is 100,000 seconds?

Divide 100,000 by 86,400 to get 1 whole day, with 13,600 seconds left. Divide 13,600 by 3,600 to get 3 whole hours, with 2,800 seconds left. Divide 2,800 by 60 to get 46 minutes, with 40 seconds left. So 100,000 seconds is 1 day, 3 hours, 46 minutes and 40 seconds. You can add the parts back together to check: 86,400 plus 10,800 plus 2,760 plus 40 equals 100,000.

Seconds in programming

In code, 86,400 is a common constant for the number of seconds in a day. Unix time counts the seconds since 1 January 1970, and dividing a Unix time stamp by 86,400 gives the number of days since that date. In Excel you can convert a Unix time stamp in A2 to a date with =A2/86400+DATE(1970,1,1) and format the result as a date and time. Keep in mind that time zones and daylight saving changes can make a local day 23 or 25 hours long, so use UTC for exact calculations.

Fun facts

A million seconds is about 11.6 days, since 1,000,000 divided by 86,400 is 11.57. A billion seconds is about 31.7 years. There are about 31.5 million seconds in a year, so a person who lives to 80 will have lived about 2.5 billion seconds. These comparisons make large numbers easier to picture.

Seconds in half a day and other fractions

Half a day has 43,200 seconds, a quarter of a day has 21,600 seconds, and one twelfth of a day, which is two hours, has 7,200 seconds. A work day of 8 hours uses one third of the 86,400 seconds, which is 28,800. A common sleep time of 8 hours uses the same amount, so a person who works 8 hours and sleeps 8 hours has 28,800 seconds left for everything else. Fractions like these help you to plan a day in time blocks and to check that the parts add up to 86,400.

A quick table of days to seconds

Use this table for fast conversions.

DaysSeconds
186,400
2172,800
3259,200
5432,000
7604,800
10864,000
302,592,000

Each row is the number of days multiplied by 86,400. You can copy the pattern into Excel by typing the days in column A and =A2*86400 in column B, then filling down. This is handy for timers, logs and reports that mix days and seconds.

Time tracking and payroll use

Many time clocks record work in seconds and then round to minutes. If an employee works 27,000 seconds, that is 7.5 hours, because 27,000 divided by 3,600 is 7.5. Payroll tools convert such totals into hours and multiply by the hourly rate. If you also need to check overtime, our overtime calculator shows the rule in a simple form. Always keep the raw seconds and round only at the final step, so that small errors do not add up over a month.

Common mistakes

The first mistake is to use 60 times 24 and forget the second factor of 60, which gives the minutes and not the seconds. The second is to treat a month as 30 days for every case. The third is to divide Excel times by 24 and not by 86,400 when the source is seconds. The fourth is to forget the square brackets in the format [h]:mm:ss, so that totals over 24 hours wrap around. The fifth is to forget leap days when you work over several years.

Practice problems

Try these. Problem 1: how many seconds are in 3 days? The answer is 259,200. Problem 2: how many seconds are in a 31 day month? The answer is 2,678,400. Problem 3: convert 7,200 seconds to hours, which is 2. Problem 4: convert 90,000 seconds to days and hours, which is 1 day and 1 hour. Problem 5: how many seconds are in 6 hours and 30 minutes? The answer is 23,400.

Quick recap

A day has 86,400 seconds, an hour has 3,600, a week has 604,800 and a common year has 31,536,000. Divide seconds by 86,400 to get days, by 3,600 to get hours, and by 60 to get minutes. In Excel, divide by 86,400 to get a time value and format it as [h]:mm:ss. Remember leap years and use UTC for exact work.

Frequently asked questions

How many seconds are in a day?

There are 86,400 seconds in one day.

How many seconds are in a week?

There are 604,800 seconds in a week.

How many seconds are in a year?

A common year has 31,536,000 seconds, and a leap year has 31,622,400.

How do I convert seconds to days in Excel?

Divide the seconds by 86,400.

How many minutes are in a day?

There are 1,440 minutes in a day.

Related guides and free tools

Leave a Reply

Your email address will not be published. Required fields are marked *