convert minutes so I can compute average time, etc

[Burdette]

I need to report average time in Hours and minutes (example 5:35 or as 5 Hrs 35 Min) and the time given me is in text as hors and minutes. How do I convert to I can compute he average and report back in the desired format

 

[Andrew Poulsom]

Please post a sample of the data that you want to average.

 

[Rick Rothstein]

...the time given me is in text as hors and minutes

Can you show us what these "text times" look like?

 

[adam087]

How's this for you?

Excel 2010

	A	B	C	D	E
1	Input	Count Minutes
2	0:53	53		Output	4:05
3	7:47	467
4	6:33	393
5	0:36	36
6	5:50	350
7	2:01	121
8	9:10	550
9	1:50	110
10	0:15	15
11	5:50	350

<colgroup><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E2 =INT(AVERAGE(B2:B11)/60)&":"&TEXT(MOD(AVERAGE(B2:B11), 60), "00") B2 =(VALUE(LEFT(A2,FIND(":",A2)-1))*60)+VALUE(RIGHT(A2, LEN(A2)-FIND(":", A2))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

/AJ

 

[Burdette]

How do I attach a file for you to see it in Excel?

 

[Burdette]

See above do not know how to attach the file here

 

[Andrew Poulsom]

Just copy a sample of your data and paste it into a reply.

 

[Burdette]

I will give it a try --- Thanks