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