# 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
###### Who is Participating?

Commented:
(size of file x 1024) / time taken (minutes) = speed in MB per Minute
(200GB x 1024) / 28 = xx
0

Author 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

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

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

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

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

Author Commented:
0

Commented:
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.