Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
questionnaire providing list of requirements | Excel Discussion (Misc queries) | |||
Complete path info on Excel window | Excel Discussion (Misc queries) | |||
Providing a way to return to the place before you followed a link. | Excel Discussion (Misc queries) | |||
Providing Toolbars to Workgroup | Excel Discussion (Misc queries) | |||
Providing for Applicaiton Update | Excel Programming |