anybody?
 

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

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

Just format e1 as general?

--
HTH

Bob Phillips

"cjjoo" wrote in
message ...

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

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" wrote in message
...
Just format e1 as general?

--
HTH

Bob Phillips

"cjjoo" wrote in
message ...

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

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