connection speed formula question

[Jing]

I'm creating a sheet to keep track of connection speeds.
so example would be:

total bandwidth used = 165.6222GB
Number of Days = 10
product of the two above #'s is the connection speed to obtain it.

A2 is the bandwidth used, B2 is the # of days
D2 is where i am having an issue.

i would like to get one formula that will provide me with the connection speed to achieve 165.6222GB in 10 days (in MB/s)

i can work it out manually with a calculator but it takes to long for all the accounts i am going through... if i could just enter the total used bandwidth and the # of days and just have it calculate the answer for me it would be a big help.

Thank you

 

[bensonsearch]

Hi, the below will work for you

=(((((A2/B2)/24)/60)/60)*1012)

gives MB/s, can test result by

=(d2*864000)/1012

864000 being the secs in 10 days

 

[Jing]

Thank you very much...

 

[bensonsearch]

not a problem, hope it helps