Go Back

Sum race time splits

Read time: 20 minutes

Figure 1. Sum Race Time Splits in Excel.

Let us assume that we are required to sum up different race time splits that are the results of races between several competitors, we are going to use the Excel SUM function to achieve this.

Generic Formula

=SUM(range)

The Excel SUM function determines the total of different time splits made up of hours, minutes, and seconds.

How to use the Excel SUM function

To use the SUM function in Excel, use the following 3 simple steps.

  1. Collect the different time splits from the races and arrange them into labeled columns of our worksheet.

See example illustrated below;

Figure 2. Sum Race Time Splits in Excel.

Be sure to provide empty cells for Excel to determine the TOTAL TIME taken.

  1. In our worksheet example above, the SUM formula in cell G2 is as follows;.

=SUM(A2:F2)

Figure 3. Sum Race Time Splits in Excel.

  1. Copy the modified version of the SUM formula into the other cells in the TOTAL TIME column to get the other results.

Figure 4. Sum Race Time Splits in Excel.

However, when working with times, care must be taken to input time values with the right syntax/format to display the ideal results.

Figure 5. Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

When I try to use this formula to write to cells it has a run time error. I tried using Formula instead of Array and it doesn't work either. Sub Fill_Formulas() Application.ScreenUpdating = False Application.Calculation = xlCalculateManual Range("Table7['# to make the draw]").FormulaArray = "=IF([@[Draw '#]]>0, [@[Draw '#]],IF(OR([@[Race Entered]]=EventtoDraw, EventtoDraw=""), MAX(IF([Race Entered]=[@[Race Entered]],[Draw '#]))+SUMPRODUCT(([Race Entered]=[@[Race Entered]])*(['# for Drawing]<[@['# for Drawing]]))+COUNTIFS(H$11:H11,H11, C$11:C11,C11), ""))" Application.ScreenUpdating = True Application.Calculation = xlAutomatic End Sub
Solved by D. J. in 12 mins
When I try to use this formula to write to cells it executes the first 2 but has a run time error on the 3rd. I tried using Formula instead of Array and it doesn't work either. Sub Fill_Formulas() Application.ScreenUpdating = False Application.Calculation = xlCalculateManual Range("Table7[Multi Horse]").Formula = "=COUNTIFS([Race Entered],[@[Race Entered]], [Rider],[@Rider])" Range("Table7[Count for Pref]").Formula = "=MAX([Multi Horse])/[@[Multi Horse]]*(COUNTIFS(H$11:H11,H11,J$11:J11,J11))-1" Range("Table7['# to make the draw]").FormulaArray = "=IF([@[Draw '#]]>0, [@[Draw '#]],IF(OR([@[Race Entered]]=EventtoDraw, EventtoDraw=""), MAX(IF([Race Entered]=[@[Race Entered]],[Draw '#]))+SUMPRODUCT(([Race Entered]=[@[Race Entered]])*(['# for Drawing]<[@['# for Drawing]]))+COUNTIFS(H$11:H11,H11, C$11:C11,C11), ""))" Range("Table7['# for Drawing]").Formula = "=IF([@[Draw '#]]>0, "",IF([@[Draw Pref (0-10)]]>0, [@[Draw Pref (0-10)]],IF([@[Multi Horse]]>1,[@[Count for Pref]],RANDBETWEEN(0,1.5+MAX([Multi Horse])))))" Application.ScreenUpdating = True Application.Calculation = xlAutomatic End Sub
Solved by K. J. in 13 mins
i want a macro that separates that splits the bold text and regular text.
Solved by E. H. in 25 mins

Leave a Comment

avatar