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