To calculate download time, divide the file size by your actual download speed. The key is to use the same units for both: file sizes are usually shown in megabytes (MB) or gigabytes (GB), while internet speeds are usually advertised in megabits per second (Mbps).
\text{Download time} = \frac{\text{File size}}{\text{Download speed}}
Because there are 8 bits in a byte, divide the advertised Mbps speed by 8 to get megabytes per second (MB/s).
Understand MB, GB, and Mbps
Internet providers usually advertise speed in megabits per second (Mbps). File sizes are usually shown in megabytes (MB) or gigabytes (GB).
- 1 byte = 8 bits
- 1 megabyte (MB) = 8 megabits (Mb)
- 1 gigabyte (GB) = 1,000 MB, in most consumer storage and download contexts
- 1 Mbps = 1 megabit per second
- 8 Mbps = 1 MB per second
So, a 100 Mbps connection has a theoretical maximum download speed of:
100 \div 8 = 12.5 \text{ MB/s}
Basic Download Time Formula
Use this formula:
\text{Download time in seconds} = \frac{\text{File size in MB} \times 8}{\text{Speed in Mbps}}
Then divide the result by 60 for minutes, or by 3,600 for hours.
Example: 500 MB file at 100 Mbps
\frac{500 \times 8}{100} = 40 \text{ seconds}
A 500 MB file takes about 40 seconds to download at a constant 100 Mbps.
Example: 2 GB file at 50 Mbps
First convert 2 GB to MB:
2 \times 1,000 = 2,000 \text{ MB}
Then calculate:
\frac{2,000 \times 8}{50} = 320 \text{ seconds}
320 \div 60 = 5.33 \text{ minutes}
A 2 GB file takes about 5 minutes and 20 seconds at 50 Mbps.
Quick Download Time Table
This table assumes ideal conditions and uses decimal units: 1 GB = 1,000 MB.
| File size | 25 Mbps | 50 Mbps | 100 Mbps | 300 Mbps | 1 Gbps |
|---|---|---|---|---|---|
| 100 MB | 32 sec | 16 sec | 8 sec | 2.7 sec | Under 1 sec |
| 500 MB | 2 min 40 sec | 1 min 20 sec | 40 sec | 13 sec | 4 sec |
| 1 GB | 5 min 20 sec | 2 min 40 sec | 1 min 20 sec | 27 sec | 8 sec |
| 5 GB | 26 min 40 sec | 13 min 20 sec | 6 min 40 sec | 2 min 13 sec | 40 sec |
| 10 GB | 53 min 20 sec | 26 min 40 sec | 13 min 20 sec | 4 min 27 sec | 1 min 20 sec |
These estimates assume the connection consistently delivers the advertised speed. Real download times are often longer.
Calculate Download Time in Excel or Google Sheets
If file size in GB is in cell A2 and internet speed in Mbps is in cell B2, use:
=(A2*1000*8)/B2
This returns the estimated time in seconds.
To show the result in minutes:
=(A2*1000*8)/B2/60
Example
| File size (GB) | Speed (Mbps) | Formula | Estimated time |
|---|---|---|---|
| 2 | 50 | =(A2*1000*8)/B2 |
320 seconds |
| 2 | 50 | =(A2*1000*8)/B2/60 |
5.33 minutes |
| 10 | 300 | =(A2*1000*8)/B2/60 |
4.44 minutes |
Use Your Real Speed, Not the Advertised Speed
The advertised speed is a maximum under ideal conditions. Your actual download speed may be lower because of:
- Wi-Fi signal strength and interference
- Distance from the router
- Network congestion
- The website or server’s upload capacity
- The number of devices using the connection
- VPNs, security software, or network restrictions
- Older router or device hardware
- Data caps or provider traffic management
Before estimating an important download, run a speed test while connected in the same way you would normally download files. Use the measured download speed—not the advertised plan speed—in your calculation.
Example using real speed
A file is 3 GB, and your speed test shows 72 Mbps.
Convert the file size:
3 \times 1,000 = 3,000 \text{ MB}
Calculate:
\frac{3,000 \times 8}{72} = 333.3 \text{ seconds}
333.3 \div 60 = 5.56 \text{ minutes}
The estimated download time is about 5 minutes and 34 seconds.
Convert Download Speed to MB/s
To make estimates easier, convert your internet speed to megabytes per second:
\text{MB/s} = \frac{\text{Mbps}}{8}
| Advertised speed | Approximate download speed |
|---|---|
| 25 Mbps | 3.1 MB/s |
| 50 Mbps | 6.3 MB/s |
| 100 Mbps | 12.5 MB/s |
| 300 Mbps | 37.5 MB/s |
| 500 Mbps | 62.5 MB/s |
| 1 Gbps | 125 MB/s |
Then use:
\text{Download time} = \frac{\text{File size in MB}}{\text{Download speed in MB/s}}
For example, a 1,200 MB file at 12.5 MB/s takes:
1,200 \div 12.5 = 96 \text{ seconds}
That is 1 minute and 36 seconds.
Common Mistakes to Avoid
Confusing megabits and megabytes
This is the most common error. Internet speed is usually in megabits, while file size is usually in megabytes. Always divide Mbps by 8 before comparing it with MB.
Using the advertised speed for every estimate
Advertised speeds are maximums. Use a recent speed-test result for a more realistic estimate.
Ignoring overhead
Download protocols, encryption, network overhead, and server limits reduce effective speed. A connection may be rated at 100 Mbps but deliver less during a real download.
Assuming speed stays constant
Speed can rise and fall during a download. Your estimate is most accurate for large files and stable wired connections.
Forgetting other devices
Streaming, video calls, cloud backups, gaming, and other downloads share the same connection. Pause or limit other activity for a more accurate estimate.
Practical Examples
Downloading a movie
A 4 GB movie on a 100 Mbps connection:
4,000 \times 8 \div 100 = 320 \text{ seconds}
Estimated time: about 5 minutes and 20 seconds.
Downloading a game update
A 25 GB update on a 300 Mbps connection:
25,000 \times 8 \div 300 = 666.7 \text{ seconds}
Estimated time: about 11 minutes and 7 seconds.
Downloading a PDF
A 20 MB PDF on a 25 Mbps connection:
20 \times 8 \div 25 = 6.4 \text{ seconds}
Estimated time: about 6 seconds.
Quick Reference
| What you have | Conversion |
|---|---|
| Mbps to MB/s | Divide by 8 |
| GB to MB | Multiply by 1,000 |
| Seconds to minutes | Divide by 60 |
| Download time | File size in MB times 8, divided by speed in Mbps |
Convert file size and internet speed into matching units, use your measured speed rather than the advertised speed, and remember that Wi-Fi, server limits, and other devices can make real downloads slower.