Formatting numbers


Posted by Mona Gloff on November 04, 2001 6:19 PM

I coach runners. How can I enter times and allow the times to average? It keeps converting the times to other formats. HELP!!!!!



Posted by Aladin Akyurek on November 04, 2001 9:04 PM

Mona,

You can just use AVERAGE. Averaging e.g.,

0:08:04
0:06:08

gives 0:07:06.

Aladin

=======