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