Formula Needed

[CherryMan]

I am in need of a formula that will help me create a running schedule. We currently run 2 bins of fruit per minute. I would like to enter how many bins we have to run during the day to project when we will be finished. This will be carrried out for all the growers that we have.

Example:
Grower 001 has 60 bins. We will start running at 8:00 AM. So in theory we should be done with grower 001 at 8:30. Then grower 002 has 120 bins. We will start 002 at 8:30 and finish at 9:30.

The process will repeat all day.

 

[PaddyD]

hi - welcome to the board.

with start time in a1 & number of bins in a2:

=A1+(B1/(2*60*24))

...format result cell for time.

 

[CherryMan]

Thank you very much Paddy. It works great.