I have Column A containing distance, and Column B containing time. I wish to put a formula in Column C to express the speed.
The number format of Column A is 'general'.
The number format of Column B is 'custom': [h]:mm:ss.
The (rather obvious) formula =a/b in Column C gives a wrong answer -- for example, 8.9km in 00:44:06 gives an answer of 290.6.
What am I doing wrong??
Thanks in advance.
(I use Excel 2003 on Win XP Pro.)
The number format of Column A is 'general'.
The number format of Column B is 'custom': [h]:mm:ss.
The (rather obvious) formula =a/b in Column C gives a wrong answer -- for example, 8.9km in 00:44:06 gives an answer of 290.6.
What am I doing wrong??
Thanks in advance.
(I use Excel 2003 on Win XP Pro.)