anybody?

[cjjoo]

this is my problem:

A1 time in [1:00am]

b1 time out [1:45AM]

c1 running hours
formula= mod(b1-a1,1) [h]

d1 km

e1 running hours/km
=c1/d1???

[Gary''s Student]

Remember that time differences, however they are displayed, are actually
numerically fraction of a day. 45 minutes is acually .03125

=24*C1/D1

--
Gary''s Student


"cjjoo" wrote:

>
> this is my problem:
>
> A1 time in [1:00am]
>
> b1 time out [1:45AM]
>
> c1 running hours
> formula= mod(b1-a1,1) [h]
>
> d1 km
>
> e1 running hours/km
> =c1/d1???
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=470125
>
>

[Bob Phillips]

Just format e1 as general?

--
HTH

Bob Phillips

"cjjoo" <[email protected]> wrote in
message news:[email protected]...
>
> this is my problem:
>
> A1 time in [1:00am]
>
> b1 time out [1:45AM]
>
> c1 running hours
> formula= mod(b1-a1,1) [h]
>
> d1 km
>
> e1 running hours/km
> =c1/d1???
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=470125
>

[Bob Phillips]

Of course Gary is right as well, you need to convert the time to decimal,
but wouldn't you do it the other way around to get kph, that is

E1: = D1/(C1*24)

--
HTH

Bob Phillips

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> Just format e1 as general?
>
> --
> HTH
>
> Bob Phillips
>
> "cjjoo" <[email protected]> wrote in
> message news:[email protected]...
> >
> > this is my problem:
> >
> > A1 time in [1:00am]
> >
> > b1 time out [1:45AM]
> >
> > c1 running hours
> > formula= mod(b1-a1,1) [h]
> >
> > d1 km
> >
> > e1 running hours/km
> > =c1/d1???
> >
> >
> > --
> > cjjoo
> > ------------------------------------------------------------------------
> > cjjoo's Profile:
> http://www.excelforum.com/member.php...o&userid=26916
> > View this thread:
http://www.excelforum.com/showthread...hreadid=470125
> >
>
>

[Roger Govier]

Hi

Excel stores times as a fraction of a day, therefore you need to multiply by
24 to get real hours.
=(c1*24)/d1

Regards

Roger Govier


cjjoo wrote:
> this is my problem:
>
> A1 time in [1:00am]
>
> b1 time out [1:45AM]
>
> c1 running hours
> formula= mod(b1-a1,1) [h]
>
> d1 km
>
> e1 running hours/km
> =c1/d1???
>
>