| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
anybody?
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
