Solved

Formula for Data Transfer Rate

Posted on 2013-05-23
9
1,658 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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
 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

This collection of functions covers all the normal rounding methods of just about any numeric value.
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 …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…

777 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