Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formatting

ResolvedVersion 2003

Lindsey has attended:
Excel Intermediate course

Formatting

How do you add a long list of times together (eg 05:04:13 = hours:minutes:seconds)?

RE: Formatting

Hi Lindsey

Thank you for your question.

Excel is happy to work with durations in the same way as dates. Enter your values in the 00:00:00 format for hours, minutes and seconds and you will find that the standard + - * / operators apply along with functions such as SUM().

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Tue 23 Jun 2009: Automatically marked as resolved.

Excel tip:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.