estimated time of completion

[ltgarcia01]

Hello,

I am trying to calculate time of completion for production. The standard is 90 items an hour per person. There are 500 items to complete. If the time now is 4pm, then what time would it be to complete the 500 items if I have 3 people working. Please help I am stumped.
Thanks

 

[mikerickson]

90 items/hr
500 items

It should take 500/90 hr to complete that
Now is 16:00:00, so the work should be done at 16:00:00+TIME(500/90,0,0).
Except that TIME takes the INT of its argument so =16:00:00+(500/90)/24 would be a better formulation.

 

[Fluff]

Hi & welcome to MrExcel
How about

+Fluff New.xlsm
	D	E
1
2	Qty	500
3	Qty/Hr/Person	90
4	People	3
5	Start	16:00
6	End	17:51:07
Data

Cell Formulas
Range	Formula
E6	E6	=E5+(E2/E3/E4/24)

 

[ltgarcia01]

YES!!! THIS is what I was looking for. Thank you all so much. ?

 

[Fluff]

Glad we could help & thanks for the feedback.