Formula
 

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.

Formula
 

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

"TJAC" wrote in message
...
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.

Formula
 

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


"David Biddulph" skrev:

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

"TJAC" wrote in message
...
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.

Formula
 

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

"excelent" wrote in message
...
say u have :
A1=125 B1=01:00
A2=250 B2= =A2/A1*B1


"David Biddulph" skrev:

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

"TJAC" wrote in message
...
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.