Trying to calculate the number of packets transferred in a 15 minute session

  • Thread starter Thread starter darkwing_duck
  • Start date Start date
D

darkwing_duck

OK, this should be really easy, but the number I'm coming up with
seems way too high. Rather than bias anything by showing my
(presumably) incorrect Excel formula, let me just say this:

If 30kb is transferred in 1 second, how many Megabytes are transferred
in 15 minutes?

The number I'm coming up with is 27 Gigabytes but that can't be right.

TIA,
Robert
 
There are 900 seconds in 15 minutes, so you can transfer 900 x 30 kb
in that time, i.e 27000 kb, or 27 Mb (not Gb).

Hope this helps.

Pete
 
Minutes * 60 * 30 / 1024

15 minutes * 60 sec per min * 30kb per sec / 1024 (kb per mb)

A1 = 15 (as an integer)

=A1*60*30/1024

=26.37mb
 
OK, this should be really easy, but the number I'm coming up with
seems way too high. Rather than bias anything by showing my
(presumably) incorrect Excel formula, let me just say this:

If 30kb is transferred in 1 second, how many Megabytes are transferred
in 15 minutes?

The number I'm coming up with is 27 Gigabytes but that can't be right.

TIA,
Robert
Click to expand...

I presume by kb you mean kilobit rather than kilo byte (which is usually
denoted as kB)? The answer is 3.295 MB, since 8 bits make one byte.
 
Back
Top