Summation of entries with the same date in Excel -
I have two columns with data (several thousand rows), one with dates and one with duration (hh : Time in ss) However, there are several records for each day based on the date, any way to add them, and what is the method of getting one entry per day?
Below is a picture showing a subset of a spreadsheet:
I think what could be useful to you consolidated
will be the function.
If you click on the Steps to Success: Select a border next to your existing values, if you are the same picture then I will suggest column C, and D Press For selecting data tab, on the menu bar, a button on the middle-right is consolidated.
Integrate
with highlighting on the column. Sum
for the function, highlight the data in column A, and for reference B. label
in
Dates are formatted properly, and timely formatted time such as this should be the sum of all the time given for a particular date. left column
Tell me if it works for you, if you have any questions, comment .
Comments
Post a Comment