why can't I divide number with time value?

S

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
 
A

Ardus Petus

Multiply your duration by 24 to get decimal hours

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

HTH
 
S

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 :eek:
 
S

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
 
P

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
 
Top