How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.

What formula would I use to average the two?

ANY help would be greatly appreciated, Karen

Enter the values as real times in A1 and A2
0:03:03
0:01:13

and use a formula like:
=average(a1:a2)

and give it a nice format
[mm]:ss
????

Karen wrote:

How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.

What formula would I use to average the two?

ANY help would be greatly appreciated, Karen

--

Dave Peterson

Thank you very much for your help. Is there a formula to convert the value -
Example: 02:08 into 2 min. 8 sec. in another cell so the average is easier to
read?
Thank you, Karen

"Dave Peterson" wrote:

Enter the values as real times in A1 and A2
0:03:03
0:01:13

and use a formula like:
=average(a1:a2)

and give it a nice format
[mm]:ss
????

Karen wrote:

How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.

What formula would I use to average the two?

ANY help would be greatly appreciated, Karen

--

Dave Peterson

=MINUTE(A3)&" min. "&SECOND(A3)&" sec."
--
David Biddulph

"Karen" wrote in message
...
Thank you very much for your help. Is there a formula to convert the
value -
Example: 02:08 into 2 min. 8 sec. in another cell so the average is easier
to
read?
Thank you, Karen

"Dave Peterson" wrote:

Enter the values as real times in A1 and A2
0:03:03
0:01:13

and use a formula like:
=average(a1:a2)

and give it a nice format
[mm]:ss
????

Karen wrote:

How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.

What formula would I use to average the two?

ANY help would be greatly appreciated, Karen

--

Dave Peterson

Thank you SO MUCH David - You have been a big help! You made my day!
You are da bomb!

Karen

"David Biddulph" wrote:

=MINUTE(A3)&" min. "&SECOND(A3)&" sec."
--
David Biddulph

"Karen" wrote in message
...
Thank you very much for your help. Is there a formula to convert the
value -
Example: 02:08 into 2 min. 8 sec. in another cell so the average is easier
to
read?
Thank you, Karen

"Dave Peterson" wrote:

Enter the values as real times in A1 and A2
0:03:03
0:01:13

and use a formula like:
=average(a1:a2)

and give it a nice format
[mm]:ss
????

Karen wrote:

How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.

What formula would I use to average the two?

ANY help would be greatly appreciated, Karen

--

Dave Peterson

You could keep it in the same cell and give that cell a custom format of:

mm "min" ss "sec"
(format|cells|number tab|custom category)

Karen wrote:

Thank you very much for your help. Is there a formula to convert the value -
Example: 02:08 into 2 min. 8 sec. in another cell so the average is easier to
read?
Thank you, Karen

"Dave Peterson" wrote:

Enter the values as real times in A1 and A2
0:03:03
0:01:13

and use a formula like:
=average(a1:a2)

and give it a nice format
[mm]:ss
????

Karen wrote:

How do I go about averaging the following?
Cell A1 = 3 min. 3 sec.
Cell A2 = 1 min. 13 sec.

What formula would I use to average the two?

ANY help would be greatly appreciated, Karen

--

Dave Peterson


--

Dave Peterson