Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|