Download Speed Calculator.

[pantsmonkey]

Hey guys im sitting here waiting for a torrent to finish downloading and I jumped into Excel to work out a few rough estamates file downloads based on

File Size
Download speed availability

I work out a few different file sizes 100 MB 200 MB up to 2 gb and then figured why not just make a little calculator.

What im after is a small calculator that allows me to put in the download speed and fille size and it will work out the download time in hours minutes and seconds.

My formula is =K16*1024/J18/60

K16 is the download speed im getting I actually setup a range in cells from K16 to K28 starting at 150 K moving down to 5K
J18= file size

This illustrates how long the download will take if the speed changes.

My problem is if its greater than 60 minutes it displays a number than greater than 60 and that looks messy so I would like to somehow have it.

if > 60 then cell = cell/60 moving the remainder to minutes (some kind of input mask"hour(s)")minutes.

Hope that makes some sense the idea is probably silly but meh.


Sorry for the long post ive just realised I took so long my download is now finished

cheers

 

[erik.van.geit]

Hi, pantsmonkey,

take a look on the sheet below
column B is formatted as hh:mm
starting with this, I think you will be able to adapt your formula

kind regards,
Erik

Map1.xls
	A	B	C	D
1	minutes	formatted
2	10	0:10
3	20	0:20
4	30	0:30
5	40	0:40
6	50	0:50
7	60	1:00
8	70	1:10
9	80	1:20
10	90	1:30
11	100	1:40
12	110	1:50
13	120	2:00
14	130	2:10
15	140	2:20
16	150	2:30
17	160	2:40
18	170	2:50
Blad6