Solved

Formula for Data Transfer Rate

Posted on 2013-05-23
9
1,588 Views
Last Modified: 2013-05-23
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
Comment
Question by:securitythreat
  • 5
  • 3
9 Comments
 
LVL 15

Accepted Solution

by:
Ian Meredith earned 395 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

by:securitythreat
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

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

Expert Comment

by:Ian Meredith
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 1

Author Comment

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

Author Comment

by:securitythreat
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

by:securitythreat
ID: 39193216
Awesome help with great added advise...
0
 
LVL 15

Expert Comment

by:Ian Meredith
ID: 39193341
You're welcome!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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 …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now