Hello:
I want to calculate a throughput. Ex. 1.59MB took 1:02 (mm:ss) to transfer.
A1=1.59 A2=1:02 (mm:ss)
A3 should be 1.54(rounded)(mm:ss)
Simple division, except the Text value in A2 does not work? I can take (1.59/62)*60 to calc MB/min. I need to reference the previous cell instead of the number 62.
Do I need to convert to seconds (and how) then divide, and then what format do I use?
Thanks for your consideration..
I want to calculate a throughput. Ex. 1.59MB took 1:02 (mm:ss) to transfer.
A1=1.59 A2=1:02 (mm:ss)
A3 should be 1.54(rounded)(mm:ss)
Simple division, except the Text value in A2 does not work? I can take (1.59/62)*60 to calc MB/min. I need to reference the previous cell instead of the number 62.
Do I need to convert to seconds (and how) then divide, and then what format do I use?
Thanks for your consideration..