Progress bar to show both percentage completion and time left

Hi,

Can anyone help me on how to show progress bar for both percentage completion and time left.

The code below is already created with percentage completion. Just to add time left.

Please Login or Register  to view this content.

Hi, see my post #27 in this thread:
http://www.excelforum.com/excel-prog...ml#post3712514

The problem is how to define the time the macro would take (this would vary on what the data is you are copying from A1, what your machine specification is, how much of the CPU is available to the application at a given time etc etc). You will need to run your macro to get an idea of how long it takes but it will only ever be very approximate.

Hi ragulduy,

Thanks for the details explanation. Now I am fully understand why the left display by windows when we copy and paste file from one folder to another always inaccurate. .

The code above working fine but the time left not display in time format.

I have added this but still the same.

Please Login or Register  to view this content.

It display long number, maybe need to convert to time format. e.g. XX Mins, XX Sec.

Hi shg,

Thanks for your vba code.

I want question on your declaration f = Timer , and fETC = (1 / fPct - 1) * (Timer - f).


If possible, I want to convert to time format. e.g. XX Mins, XX Sec. please help thanks.