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

[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

 

[Pete_UK]

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

 

[T. Valko]

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

 

[Schizoid Man]

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

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.