To: R.VENKATARAMAN
Thank You,
That gets me through one step of my process...


"R.VENKATARAMAN" wrote:

9am-7am gives 0.00 in time. if you format as number it will give you
0.08333333... that means 0.083333333.... day. so 864/.0833333......./24 will
give your per hour i.e. 432

A1 ------7:00am
A2------9:00 am
A3------A2-A1 formatted as number will be 0.0833333
B2-----864
B3----- =B2/A3/24 will give you 432


LostNFound wrote in message
...
I want to use excel to subtract two times and then divide a specified cell
by
the sum and return the value. Example: I get to point A @ 7:00am depart @
9:00am and deliver 864 boxes. How many boxes per hour did I deliver? When
I
sum 9:00am - 7:00am I get 2:00 then if I divide 864 by that I get 0:00 if
I
leave it formatted as time. And if I change the format to general I get
10368?? I should get 432