Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
How to combine duplicate rows and sum the values in Excel?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hi guys,
This is something that has been troubling me for a month! As you can see in the image below, I am looking for a possible way of combining the similar data and adding the recorded "Times" for each contract. So sometimes an employee clocks in multiple times on the same date and the time in the contract gets recorded multiple times. I am looking for a way of combining these times so it only shows, and added time duration per date for a given contract.
Any help???
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes