I'm working on a project where I'm running some test to determine how long a system will take to run a data migration tool with specific amounts of data from one system to another. I want to compare the transfer times of using a USB storage device and an eSATA storage device.

The recorded times are as:

USB Device - 2GB of Data - 12mins

USB Device - 5GB of Data - 38mins

USB Device - 20GB of Data - 2Hrs

USB Device - 50GB of Data - Not Recorded

eSATA Device - 2GB of Data - 3mins

eSATA Device - 5GB of Data - 7mins

eSATA Device - 20GB of Data - 21mins

eSATA Device - 50GB of Data - 53mins

What I would like to do is get a formula (using the data captured above) that I can use that I'll be able to "mathematically" calculate how long it will take to migrate X amount of data. YES I can assume how long it will take but I'll need some kind of formula. Please help if possible

Then, do this in Excel:

Click on cell A1, then press Ctrl+1

Set the format to Number with 1 decimal points

Type the amount of data in GB into cell A1

Click on cell A2, then press Ctrl+1

Set the format to Number with 0 decimal points

Type this formula into cell A2 for the USB time in minutes: =A1*(120/20)

Click on cell A3, then press Ctrl+1

Set the format to Number with 0 decimal points

Type this formula into cell A2 for the eSATA time in minutes: =A1*(53/50)