why can't I divide number with time value?

[Sirritys]

I'm trying to make a little sheet that counts for example points /
hour.

I calculate spent time as "ending time - starting time". And now when
I'm trying to divide my "points" with this with time spent excel gives
me an error.

I guess this solution is simple, but I just didn't get it myself

-Sirritys

 

[Ardus Petus]

Multiply your duration by 24 to get decimal hours

points_per_hour = points / (ending time - starting time)*24

HTH

 

[Sirritys]

Thanks for answer, althought I realisez I had to DIVIDE not multiply
with 24 ;-)

Woulnd't have thought that without you.

Amazing that excel does't count that right just dividing it normally
like points / time.

I guess ppl then don't ever need to count i.e. km/h

 

[Michael Bednarek]

I'm trying to make a little sheet that counts for example points /
hour.

I calculate spent time as "ending time - starting time". And now when
I'm trying to divide my "points" with this with time spent excel gives
me an error.

I guess this solution is simple, but I just didn't get it myself

This works here:
A1: T1 (Start Time) (formatted as hh:mm)
B1: T2 (End Time) ditto
C1: P (Points) (formatted General)
D1: =C1/24/(B1-A1) (formatted as Number)
or
D1: =C1/((B1-A1)*24)

 

[Sirritys]

That works also. Depends on the place of the brackets obviously =)

Obviously excel changes "time" value to "how many days" if you change
it's format to number. I just have to learn to outsmart Excel =)

Thanks for help all

-Sirritys

 

[Pete_UK]

Excel stores time values internally as a fraction of a 24-hour day, so
if you want to evaluate things like km/hour or litres/min, you have to
introduce factors of 24 or 24*60 respectively to give the correct
answers.

Hope this helps.

Pete