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.
LVL 1
securitythreatAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ian MeredithConnect With a Mentor Commented:
(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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.