You will need a start date in order to evaluate the completion date.
Essentially:
= start_date + total_time / hrs_per_day
Hope this helps.
Pete
On Apr 25, 12:22 am, Richard <Rich...@discussions.microsoft.com>
wrote:
> L1 = Hours worked per day
> G:G = Total time in hours
> L2 = Completion date
> How would you write this formula to return a completion date?
> Thanks in advance!!