enter image description hereIn Google sheets I have following formula "=(C1-A1) + (B1-D1)" to get the duration between two times, including a break. I have this in several cells and before I could mark these cells and get the correct sum in the right corner. But now when I mark more than two cells I get an incorrect sum. When I use the formula "sum" I also get the correct sum, but it is different from the sum in the right corner. I have the right format, which is duration so I can't figure out what the issue could be and what have changed since it worked before?enter image description here

  • Those aren't elapsed times, but daily times, so Mod(10+10+10 , 24)=6
    – Daniele
    Aug 29 at 17:13
  • @Daniele , do you know what I can do to get the correct sum? Aug 29 at 17:49
  • double check on the format of those times ... they must be duration and not daily times
    – Daniele
    Aug 29 at 18:28
  • @Daniele Oh okay, so everything should be in format duration? Thank you!:) Aug 29 at 18:37
  • @Daniele . Hi again, I changed the times to duration and got the right sum now for total hours. I also have a formula for hours before and after a certain time. In the cells in which I have this formula I have the format duration, but the sum gets wrong still. You can see the formula in the first picture, “Om” means “if”. Do you know what I can do? Aug 30 at 13:53


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.