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

 

[Guest]

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

=24*C1/D1

 

[Bob Phillips]

Just format e1 as general?

 

[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

Just format e1 as general?

--
HTH

Bob Phillips

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

 

[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