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.

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

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}

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

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.