Hi Roger

Try this.

The format should be [mm]:ss

Entry must be as 0:00:00

Use sum function to calculate total.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Roger D" wrote:

I want to enter a column of data as time DURATION (not clock time) in mm:ss
format and then sum the total. What cell format should I select for the
duration entries (mm:ss does not work) and what calculation steps do I need
to use to sum those durations?