Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • How to get address of last cell in range in Excel
  • How to get last row in numeric data in Excel
  • Find closest match in Excel
  • Vlookup Examples in Excel

Data Analysis Examples

  • Example of COUNTIFS with variable table column in Excel
  • Number and Text Filters Examples in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Use Data Form to input, edit and delete records in Excel
  • How to Sort by Color in Excel

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation only dates between
  • Excel Data validation specific characters only
  • Excel Data validation don’t exceed total
  • Excel Data validation must contain specific text

Sum race time splits in Excel

by

If you need to add up (sum) up race time splits that are some combination of hours, minutes, and seconds, you can simply use the SUM function.

However, you must take care to enter times with the right syntax and use a suitable time format to display results, as explained below.

Formula

=SUM(range)

Explanation

The formula in cell H5 is:

=SUM(C5:G5)

Enter times in correct format

You must be sure that times are correctly entered in hh:mm:ss format. For example, to enter a time of 9 minutes, 3 seconds, type: 0:09:03

Worked Example:   Apply Previous Cell Styles Using Format Painter in Excel

Excel will show the time in the formula bar as 12:09:03 AM, but will record the time properly as a decimal value.

Internally, Excel tracks times as decimal numbers, where 1 hour = 1/24, 1 minute = 1/(24*60), and 1 second = 1/(24*60*60). How Excel displays time depends on what number format is applied.

Worked Example:   Calculate running total in Excel

Use a suitable time format

When working with times, you must take care to use a time format that makes sense to display times that represent durations.

To access and apply custom time formats, select the cell(s), then use Control + 1 (Command + 1 on a Mac), then Number > Custom.

Worked Example:   Change Cell Styles in Excel

These are the number formats used in the example shown:

mm:ss // split times
h:mm:ss // total time

If total times may exceed 24 hours, use this format:

[h]:mm:ss

The square bracket syntax tells Excel not to “roll over” times greater than 24 hours.

Post navigation

Previous Post:

Two ways to sum time over 30 minutes in Excel

Next Post:

Pad week numbers with zeros in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Split dimensions into two parts in Excel Worksheet
  • Get position of 2nd 3rd and more instance of character in Excel
  • How to Remove Leading Spaces in Excel
  • How to extract last two words from text string in Excel
  • SUBSTITUTE function vs REPLACE function in Excel
  • Display Date is same month in Excel
  • Add days exclude certain days of week in Excel
  • Convert time to time zone in Excel
  • Two ways to sum time over 30 minutes in Excel
  • Convert Excel time to decimal minutes
  • Calculate payment for a loan in Excel
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles