Adding up a column of minutes & seconds

A

ann-marie

What formula/how do I add up a column containing 1:10
minutes and seconds. Do I do an =sum and format for
time???? Can you help, please.
 
A

Aladin Akyurek

I take it that you have multiple time values in that column...

=SUM(A1:A10)

Custom format the formula cell as [m]:ss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Delete text from bulleted paragraphs 1
Images are pixelated when saving to PDF 0
Cumulative time calculation in Excel 2003 3
Slow when "Mark all as read" 3
Slow mark all as read 0
Countdown macro - display settings 2
Summing minutes and seconds 2
Convert text entered as minutes/seconds to minutes 1

Top