why can't I divide number with time value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sirritys - 04 Jul 2006 08:43 GMT

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

Reply to this Message

Ardus Petus - 04 Jul 2006 08:54 GMT

Multiply your duration by 24 to get decimal hours

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

HTH
--
AP

> I'm trying to make a little sheet that counts for example points /
> hour.
[quoted text clipped - 6 lines]
>
> -Sirritys

Reply to this Message

Sirritys - 04 Jul 2006 09:19 GMT

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 :o

Reply to this Message

Michael Bednarek - 04 Jul 2006 10:02 GMT

>I'm trying to make a little sheet that counts for example points /
>hour.
[quoted text clipped - 4 lines]
>
>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)

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message

Sirritys - 05 Jul 2006 07:49 GMT

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

> This works here:
> A1: T1 (Start Time) (formatted as hh:mm)
[quoted text clipped - 3 lines]
> or
> D1: =C1/((B1-A1)*24)

Reply to this Message

Pete_UK - 05 Jul 2006 09:28 GMT

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

> That works also. Depends on the place of the brackets obviously =)
>
[quoted text clipped - 12 lines]
> > or
> > D1: =C1/((B1-A1)*24)

Reply to this Message

Rate this thread: