Solved

# Formula for Data Transfer Rate

Posted on 2013-05-23
Medium Priority
2,005 Views
I know what time I started a transfer and what time it ended in minutes.  I know how big the file size is that I moved.  What is the excel formula for calculating speed per minute.

Start Time - 3:12 p.m.
End Time - 3:40 p.m.
Time Taken - 00:28
Transfer Rate - ?
Size - 200GB

I'm looking for the formula to use in excel not the answer written.
0
Question by:securitythreat
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 5
• 3

LVL 15

Accepted Solution

Ian Meredith earned 1580 total points
ID: 39192876
(size of file x 1024) / time taken (minutes) = speed in MB per Minute
(200GB x 1024) / 28 = xx
0

LVL 1

Author Comment

ID: 39192898
A present, the format for minutes is being calculated as =TEXT(D9-C9, "hh:mm").  D9 representing start time and C9 representing stop.  How do I go about counting actual minutes as it being in the format of "hh:mm" does not calculate.  Furthermore, I can't delete hours without multiplying by 60 if converting to minutes
0

LVL 1

Author Comment

ID: 39192932
Here is the file i'm trying to put this in
Transfer-Rate.xlsx
0

LVL 15

Expert Comment

ID: 39192936
Have a read of this, I would recommend using the formula

=(D9-C9)*1440

This will give total minutes betweeen two times.  Incorporate that into the speed formula and you have the right result.

http://office.microsoft.com/en-au/excel-help/calculate-the-difference-between-two-times-HP010070468.aspx
0

LVL 1

Author Comment

ID: 39192958
I believe the =(B2-A2)*1440 Total minutes between two times (295)  was the kicker.. thank you
0

LVL 1

Author Comment

ID: 39192959
Crap.. it didn't let me change the rating.. I tried to give an A.. thank you
0

LVL 1

Author Closing Comment

ID: 39193216
0

LVL 15

Expert Comment

ID: 39193341
You're welcome!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
###### Suggested Courses
Course of the Month11 days, 1 hour left to enroll