On Sun, 15 Mar 2009 00:31:04 -0000, "Jellifish" wrote:

I owe Jellyfish a huge apology.

Distance/(time * 24) does in fact give the correct answer.
When I tried it the answer looked weird and I left it at that. However if I
had formatted answer cell to Number with 4 decimal places, I would have seen
the result was correct. Like using the N function.

Chuck

Comments in-line:

"Chuck" wrote in message
.. .
On Sat, 14 Mar 2009 19:41:20 -0000, "Jellifish"
wrote:

What are you trying to calculate?

If you are trying to calculate speed given a distance and a time then use:

=B3/(B4*24)

Where B3 is distance and B4 is time.