估计它在excel中的完成时间 [英] Estimating when it's done in excel
问题描述
我可以以某种方式根据时间戳和工作量做多少,估计工作完成的时间和日期?我得到这个日志,我在第A列中写了一个机器人[yyy-mm-dd hh:mm],在列B中,它记录了多少完成。
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.
推荐答案
Gary的答案是正确的,但为方便起见,如果第二行数据可以任意进度状态(不仅仅是任务的开始=隐含的0%),如果使用百分比数字格式(或小数),并且想要得到结束日期而不是持续时间,请使用以下公式:
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:
=A1+(A1-A2)/(B1-B2)*(1-B1)
这篇关于估计它在excel中的完成时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!