Formula Please

[tinferns]

I need a formula to calculate the below please...

I have a file of 1863.68 MB. Conisdering a Bandwith of 56Kbps it will take me 9 hrs and 47 minutes to download this file.

Calculation :
56 kilobytes per second * 60 seconds = 3360 kilo bytes per minute

3360 kilo bytes * 60 minutes = 201600 kilo bytes per hour or 196.87 megabites

So to download 1863.68 megabytes it will take me 9 hours and 47 minutes.

Can Excel help me with this calculation.

Please advise a formula.

Thanks in advance.

 

[cb12]

I got a slightly different answer. Sorry I don't know how to copy parts of worksheets in.

File size: 1953.13664
D/load speed: 0.056
time: 09:41:17

File size:

=1863.68*1.048

time:

=SUM(((G2/G3)/86400))

and format the time as hh:mm

Hope this helps.

 

[tinferns]

Thanks matey.. yea it works fine.. cheers.. have a nice day..

 

[tinferns]

I have another query... below is an example of data I have ...

[TABLE="width: 221"]
<TBODY>[TR]
[TD]154.00YQ0.60PZ3.60WO7.90YM121.60YR81.00GB34.49UB


Has to be converted as below
</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
YQ154.00PD#PZ0.60PD#WO3.60PD#YM7.90PD#YR121.60PD#GB81.00PD#UB34.49PD

Basically alphabets have to come before the number and has to end with PD#
Can this be done? WITHOUT VBA's please.. not comfortable with VBA's.

Await reply.

Thanks....

 

[tinferns]

Hi Guys.. is the below possible ??

I have another query... below is an example of data I have ...

[TABLE="class: cms_table, width: 221"]
<tbody>[TR]
[TD]154.00YQ0.60PZ3.60WO7.90YM121.60YR81.00GB34.49UB


Has to be converted as below
[/TD]
[/TR]
</tbody>[/TABLE]

YQ154.00PD#PZ0.60PD#WO3.60PD#YM7.90PD#YR121.60PD#GB81.00PD#UB34.49PD

Basically alphabets have to come before the number and has to end with PD#
Can this be done? WITHOUT <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250); ">VBA</acronym>'s please.. not comfortable with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250); ">VBA</acronym>'s.

Await reply.

Thanks....

 

[tinferns]

Hi Guys.. is the below possible or not ? Can someone advise me.. Pleaseee... Thnx...

Hi Guys.. is the below possible ??

I have another query... below is an example of data I have ...

[TABLE="class: cms_table_cms_table"]
<TBODY>[TR]
[TD]154.00YQ0.60PZ3.60WO7.90YM121.60YR81.00GB34.49UB


Has to be converted as below[/TD]
[/TR]
</TBODY>[/TABLE]


YQ154.00PD#PZ0.60PD#WO3.60PD#YM7.90PD#YR121.60PD#GB81.00PD#UB34.49PD

Basically alphabets have to come before the number and has to end with PD#
Can this be done? WITHOUT <ACRONYM title="visual basic for applications" style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; CURSOR: help; COLOR: rgb(51,51,51); BORDER-BOTTOM: rgb(0,0,0) 1px dotted; BACKGROUND-COLOR: rgb(250,250,250); BORDER-RIGHT-WIDTH: 0px">VBA</ACRONYM>'s please.. not comfortable with <ACRONYM title="visual basic for applications" style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; CURSOR: help; COLOR: rgb(51,51,51); BORDER-BOTTOM: rgb(0,0,0) 1px dotted; BACKGROUND-COLOR: rgb(250,250,250); BORDER-RIGHT-WIDTH: 0px">VBA</ACRONYM>'s.

Await reply.

Thanks.... ​