hi,
you are dealing with time.
24 hrs is 1 (day).
2 hours is 1/12 of 1(day) or .08 days
2 hours is not 2 (days)
your are not deviding by 2. your are deviding by .08
864/.08=10368
best you stick to whole numbers for this. avoid time.
9-7=2/864=462

-----Original 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

.