ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Providing Estimate to Complete Info on a Process (https://www.excelbanter.com/excel-programming/308676-providing-estimate-complete-info-process.html)

[email protected]

Providing Estimate to Complete Info on a Process
 
Some of the processes in my code take a long time to execute - just
lots of data to process. I'd like to give the user a better indication
of how long they will have to wait until a particular step is complete.
I currently have a method to determine the percent complete (varies by
step)

I'd like something like:

Startime = ....



Now = .....

Estimated Finish = (Now-Startime)/pct + Startime ... in hrs:min, if
necessary or :min if under 1 hr.

I've tried a few things, but a couple of problems have popped up.

1) Everything I do calc's the time as some decimal
2) There must be a better way to update the StatusBar because
in general, it won't change that fast - so if it hasn't changed, I'd
rather not call the StatusBar because it makes it flash on and off
rapidly.



All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com