Seconds to HH:MM:SS Converter — And Back Again
Seconds are how computers store durations internally. HH:MM:SS is how humans read them. This converter translates instantly in both directions: enter a number of seconds to see it broken into hours, minutes, and seconds, or enter an HH:MM:SS value to get the total second count. This is useful for video editing, database work, API responses, and anywhere duration arithmetic is needed.
For durations over 24 hours, hours continue beyond 24 (e.g., 90,000 seconds = 25:00:00). This is duration format, not clock time.
Seconds vs HH:MM:SS — When Each Format Is Useful
Seconds are the computer-friendly format. They're a single integer, easy to store in a database column, sort in a query, or do arithmetic on. Adding two durations is just addition. Finding the midpoint of a video is a single division. HH:MM:SS is the human-friendly format. It's immediately readable but requires parsing before any arithmetic. Converting at the display layer (not storage layer) is the standard pattern in software engineering.
Converting for Video Editing
Video editors routinely work with timecodes in both formats. A clip at 1:24:37 starts at 5,077 seconds from the beginning. When scripting export cuts or working with FFmpeg, you often need to specify start/end points in seconds. The formula also works backward: if a clip is 7,384 seconds long, that's 2:03:04 in HH:MM:SS. Non-linear editors (Premiere, DaVinci Resolve) display timecodes but perform all operations on frame numbers derived from the seconds count.
Duration in Database Storage
Most databases store durations as integers (seconds) or intervals. MySQL's TIME type supports HH:MM:SS up to 838:59:59, while PostgreSQL's INTERVAL type stores arbitrary durations. When reading duration data from APIs — video platforms, fitness trackers, media players — the response is almost always in total seconds (ISO 8601 duration PT1H30M or a raw integer). Always convert to seconds for storage; convert to HH:MM:SS at presentation time.
Common Duration References
Knowing a few anchor values helps sanity-check conversions: 1 minute = 60 seconds, 1 hour = 3,600 seconds, 1 day = 86,400 seconds, 1 week = 604,800 seconds. Feature films run 5,400–9,000 seconds (90–150 min). A typical podcast episode is 1,800–3,600 seconds. A marathon world record is approximately 7,400 seconds (just over 2 hours).
Quick Reference
- 1 minute = 60 seconds
- 1 hour = 3,600 seconds
- 1 day = 86,400 seconds
- 1 week = 604,800 seconds
- 1 year (365 days) = 31,536,000 seconds
- 90,000 seconds = 25:00:00 (duration over 24h is valid)
Frequently Asked Questions
How do I convert seconds to minutes and hours?
Divide total seconds by 3600 to get hours (integer part). Take the remainder and divide by 60 to get minutes. The remainder is seconds. For example, 7,384 seconds = 2 hours (7200s) + 3 minutes (180s) + 4 seconds = 2:03:04.
How do I convert HH:MM:SS to total seconds?
Multiply hours by 3600, minutes by 60, and add all three. For example, 1:30:45 = (1 × 3600) + (30 × 60) + 45 = 3600 + 1800 + 45 = 5,445 seconds.
Why do APIs use seconds instead of HH:MM:SS?
Seconds are a simple integer — easy to store, compare, sort, and do arithmetic on. HH:MM:SS is a display format that requires parsing before you can add two durations. Databases and APIs use epoch seconds or duration seconds; the client converts to HH:MM:SS for display.
What is a Unix timestamp in seconds?
A Unix timestamp is the number of seconds since January 1, 1970 00:00:00 UTC (the Unix epoch). It's the universal way to represent a specific point in time across systems. Unlike HH:MM:SS, it's unambiguous about time zone and doesn't require calendar parsing.
How are video timecodes formatted?
Video timecodes follow HH:MM:SS:FF (hours:minutes:seconds:frames). For non-drop-frame 24fps video, each second has 24 frame numbers (00–23). When editing, timecodes are typically converted to total frames or total seconds for arithmetic, then displayed back in HH:MM:SS:FF format.
How many seconds are in a day?
86,400 seconds in a day (24 × 60 × 60). A week is 604,800 seconds, and a standard year is 31,536,000 seconds (365 days). A leap year adds 86,400 seconds (366 × 86,400 = 31,622,400).
What is the difference between duration and time of day?
Duration is an amount of elapsed time (e.g., '2 hours and 30 minutes'). Time of day is a position on the clock within a 24-hour cycle (e.g., '2:30 PM'). This converter works with durations — hours can exceed 24 (e.g., 90,000 seconds = 25:00:00).