Average Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
????
 
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 said:
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
????
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
Click to expand...
Click to expand...
 
=MINUTE(A3)&" min. "&SECOND(A3)&" sec."
--
David Biddulph

Karen said:
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 said:
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
????
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
Click to expand...
Click to expand...
Click to expand...
 
Thank you SO MUCH David - You have been a big help! You made my day!
You are da bomb!

Karen

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

Karen said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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)
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 said:
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
????
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top