• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2282
  • Last Modified:

Formula for Data Transfer Rate

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
securitythreat
Asked:
securitythreat
  • 5
  • 3
1 Solution
 
Ian MeredithCommented:
(size of file x 1024) / time taken (minutes) = speed in MB per Minute
(200GB x 1024) / 28 = xx
0
 
securitythreatAuthor Commented:
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
 
securitythreatAuthor Commented:
Here is the file i'm trying to put this in
Transfer-Rate.xlsx
0
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
Ian MeredithCommented:
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
 
securitythreatAuthor Commented:
I believe the =(B2-A2)*1440 Total minutes between two times (295)  was the kicker.. thank you
0
 
securitythreatAuthor Commented:
Crap.. it didn't let me change the rating.. I tried to give an A.. thank you
0
 
securitythreatAuthor Commented:
Awesome help with great added advise...
0
 
Ian MeredithCommented:
You're welcome!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now