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