This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
Hi! I am hoping someone can help :)
I am trying to get a running total for a duration, that part is easy enough, but I need the summing to stop when the total reaches the number 8, and then have it start counting again.
For context, I am working on a schedule, the schedule is broken down by how many hours each task takes ( most tasks are no longer than 2 hours) so I need to add up multiple items to see what will fit into working hours and then have the count start again so that I can figure out how many tasks will fit into each working day.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Answer accepted by question author
This formula will reset at 8 while carrying over the remaining hours:
=LET(Total,B1+A2,IF(Total>=8,Total-8,Total))
Kevin
That is perfect! Thank you!!