Estimate exactly how long it takes to download your favorite games and large files based on size and your real-world internet speeds.
Calculating how long a game download will take manually requires converting your file size and internet connection speeds into the same base units. Because network providers measure speed in bits and storage systems measure size in bytes, we must convert bytes into bits first before performing the division.
To automatically calculate download durations (in standard time formats) inside Excel or Google Sheets, use this formula where Cell A1 is the file size in GB and Cell B1 is the download speed in Mbps:
=((A1 * 8000) / B1) / 86400
Formatting Note: To display the output cleanly as hours and minutes, right-click the formula cell → Format Cells → Time → Select custom format [h]:mm:ss.
The single most common mistake when estimating downloads is confusing **Megabits per second (Mbps)** with **Megabytes per second (MB/s)**. Internet providers advertise connections in Megabits (lowercase "b"), while systems like Steam, PlayStation Network (PSN), Xbox Live, and Epic Games Store download files in Megabytes (uppercase "B"). Because 1 byte contains 8 bits, you must always divide your advertised internet plan speed by 8 to find your maximum possible download rate in bytes (e.g., a 300 Mbps connection caps out at 37.5 MB/s).
This table compares how long standard game files take to download across common residential internet plan speeds (perfect conditions with no bandwidth throttling):
| Game File Size | Slow (10 Mbps) | Average (100 Mbps) | Gigabit Fiber (1000 Mbps) |
|---|---|---|---|
| 25 GB (Indie / Small Game) | 5h 33m | 33m 20s | 3m 20s |
| 50 GB (Standard Game) | 11h 06m | 1h 06m | 6m 40s |
| 100 GB (Triple-A Game) | 22h 13m | 2h 13m | 13m 20s |
| 150 GB (Next-Gen Massive Game) | 33h 20m | 3h 20m | 20m 00s |
Quick answers to common questions about estimating game and file download times.
This is due to the bit vs. byte conversion. Internet Service Providers (ISPs) advertise plans in Megabits (Mbps), while standard game launchers (like Steam or Xbox) measure file size in Megabytes (MB). Because 1 byte contains 8 bits, you must always divide your advertised plan speed by 8 to find your maximum real-world download rate (e.g., a 100 Mbps plan downloads at a maximum rate of 12.5 MB/s).
On a stable 100 Mbps plan under perfect conditions, a 100 GB game will take exactly 2 hours, 13 minutes, and 20 seconds to download. In the real world, this could take slightly longer due to network congestion, standard Wi-Fi overhead, or server-side limits from your launcher platform.
On a stable 300 Mbps plan, downloading Grand Theft Auto V (110 GB) will take approximately 48 minutes and 53 seconds under perfect conditions.
All the time conversion tools you need, completely free.
Convert hours and minutes to decimal format for payroll and timesheets.
Convert decimal hours back to hours and minutes format (HH:MM).
Convert any decimal time like 7.75 back to hours and minutes instantly.
Add multiple time entries and get total decimal hours for the week.
Calculate gross pay by multiplying decimal hours by your hourly rate.
Full reference chart โ every minute from 1 to 60 in decimal format.
Calculate total hours worked between start/end times with break deduction.
Multiply hours, minutes, and seconds by any multiplier factor instantly.