Formatting for Hours Minutes Seconds and totaling

[RodneyW]

I have a column of times representing hours, minutes and seconds. Most of the times are only minutes and seconds. 2:37 represents 2 minutes and 37 seconds, not 2:37AM. At the bottom of the column I need a total of hours minutes and seconds. As soon as the total exceeds 24 it reverts to whatever in excess of 24:00 hours it is. It's stuck on time as in a 24 hour clock. I need the total amount of hours, minutes and seconds.

If I need to write 2 minutes and 37 seconds as 0:02:37 I can but only the total at the bottom will include an "hour" number. All other cells will be single digit minutes and double digit seconds.

How can I do this? Thanks in advance.

 

[Cubist]

Please post some sample data. Are they all in one cell or multiple cells?
Are you still using XL 2013?

 

[RodneyW]

Please post some sample data. Are they all in one cell or multiple cells?
Are you still using XL 2013?

Yes, Excel 2013 these times are in column F

 

[Phuoc]

Try this:

Book1
	A	B
1
2	3:21	0:05:58
3	2:37
4
5
6
7
8
9
10
Sheet1

Cell Formulas
Range	Formula
B2	B2	=SUM(A2:A10)/60

 

[RodneyW]

Try this:

Book1
	A	B
1
2	3:21	0:05:58
3	2:37
4
5
6
7
8
9
10
Sheet1

Cell Formulas
Range	Formula
B2	B2	=SUM(A2:A10)/60

Works perfect, thanks!