{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Anthone 的问题《Estimating when it's done in excel》','https://www.manongdao.com/q-1163699.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Can I, somehow, based on time stamp and how much is done, estimate time and date for when a job is complete? I got this log that a bot I've made writes in column A time [yyy-mm-dd hh:mm], and in column B it wrights how much is done. It sorts it all with newest on top.
相关问题
- Excel sunburst chart: Some labels missing
- How to account for clock offsets in a distributed
- Error handling only works once
- Excel formula in VBA code
- Excel VBA run time error 450 from referencing a ra
相关文章
- Get column data by Column name and sheet name
- programmatically excel cells to be auto fit width
- Unregister a XLL in Excel (VBA)
- How to prevent excel from truncating numbers in a
- Get POSIX epoch as system_clock::time_point
- numeric up down control in vba
- Declare a Range relative to the Active Cell with V
- What's the easiest way to create an Excel tabl
Gary's answer is correct, but for convenience if the 2nd row of data can be an arbitrary progress status (not just start of task = implicitly 0%), and if you use percentage number format (or decimals) and you would like to get the end date instead of just the duration, use following formula:
Consider:
In this example the time span is 1 hour and the percent complete in the time span is 78%
Cell C1 contains:
the percent remaining to be done.
In cell D1 is the formula:
D1 yields the time required to complete 1%
Finally in E1:
the time required to complete the work!
(Note...C1,D1,E1 can be combined into a single formula)
EDIT#1
The formats of E1 and D1 were picked to display the relevent parts of the data
The format of D1,E1 is: mm-dd hh:mm:ss.00
Change this format to suit your needs!