XL stores times as fractional days, so you can use regular math
operations on them. To get fractional hours, multiply fractional days by
24:

A1: 864
A2: 7:00
A3: 9:00

A5: = A1/((A3-A2)*24)


In article ,
"LostNFound" wrote:

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