column of times, such as 2:30, 2:14, etc. how do I sum them?

H

Harlan Grove

Put your question into the BODY of your post, not in the subject line.

If your time values are numbers (they could be text that just looks
like numbers), just sum them like any other numbers, but you'd need to
give the result a number format like [h]:mm or [m]:ss depending on
whether your 2:30 and 2:14 times are hours:minutes or minutes:seconds.
The [h] and [m] format parts show hours >= 24 or minutes >= 60,
respectively.
 

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

Top