anybody?

C

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

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
 
B

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 said:
Just format e1 as general?

--
HTH

Bob Phillips

cjjoo said:
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???
Click to expand...
Click to expand...
 
R

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
 
Top