Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In front of me is Walkenbachs excel bible 2003. Chapter 10 page 220. Figure
10-10. There are two cells B2 giving a distance (the example gives 1.50 miles). C2 giving a time needed to run that distance (the example gives 00:18:45). Now in D2 he makes the calculation =B2/(C2*24) This gives the speed in mph. The part I find difficult to understand is the "24".... My normal feeling lets me divide B2 by C2 to give me a distance per 'minute'. The result of this, times 60, would give me mph. Now I think I know this 'minute' I mention is wrong. But I find it difficult to understand why to multiply by 24. Can somebody explain it more understandable? G. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Time Conversion Calculation | Excel Worksheet Functions | |||
Time calculation | Excel Worksheet Functions | |||
perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
How do I calculation time in excel in 24 hour method | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions |