Hi Sandy:
The problem is the decimal point where a colon is needed (7:28 not 7.28)
1) Use Edit | Find and Replace to convert dot to colon;
then put 60 in a blank cell, copy this, select you range of times, use
Edit|Paste Special Divide; format cells with m:ss
or
2) use a new column with (assuming first time is in A2) formula
=TIME(0,INT(A2),MOD(A2,1)*100) and format with m:ss
or
3) use
=TIME(0,SUM(INT(A2:A4))+INT(SUM(MOD(A2:A4,1)*100)/60),MOD((SUM(MOD(A2:A4,1)*100)/60),1)*60)
entered as array formula with SHIFT+CTRL+ENTER

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SandyMichalski" wrote in message
. ..
I have an excel spreadsheet that has time entered in for minutes and
seconds; ie 7 minutes and 28 seconds is shown as 7.28. How do I sum a
column with increments of time.

example:
7.28 (7 minutes & 28 seconds)
2.38 (2 minutes & 38 seconds)
5.48 (5 minutes & 48 seconds)

Total time should result in 15.54 (15 minutes & 54 seconds), but if I do a
simple SUM, the results are 15.14. HELP!