If those entries were *legal* XL times, use:
=Average(B1:E1)
However, by the looks of your data, I doubt it!
Easiest way is to enter *true* XL times in cells formatted to Time:
00:02:40
You could custom format to use the decimal for the seconds:
00:02.40
In that way you can calculate with math functions.
If your data is really plain, keyed in numbers, you'll have to perform more
complicated procedures to get what you're looking for.
SO ... which is it?
What type of values do you have in your sheet?
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jane D" <Jane
wrote in message
...
Hi,
I'm still new to formula's however seem to be finding my way around the
basics so please not too much jargon if you know the answer to my
question -
thank you.
I have a time that is documented in minutes and seconds ie 2.40 however I
believe I will need to convert these to seconds, to enable me to obtain an
average - is this correct or can anyone help me.
COL A COL B COL C COL D COL E
Average 2.40 2.14 2.32 2.52
Thanks