Formula

[TJAC]

Is it possible and if so how can I create a formula that says for example,
you fill 125 orders in one hour and 250 orders need filled. You start at
11:00am, so I need a formula that would display what time you would complete
the order filling. I can't get a formula to work because when I change the
cells to times, hours, etc, they won't calculate.

Thanks.

 

[David Biddulph]

=A3+A2/A1/24 if your 125, 250, and 11:00 are in A1, A2, & A3 respectively.

 

[excelent]

say u have :
A1=125 B1=01:00
A2=250 B2= =A2/A1*B1


"David Biddulph" skrev:

 

[David Biddulph]

But then you'd want to add the 11:00 to the result.