Troubles with time calculations, what am I missing?

[Moshpirit]

I am making a formula for time management of an event, which concerns reading some documents. I want to be able to get the time that should be given to each document, dealing with delays: starting delays and accumulated delays (the extra time used/left regarding each read document).
So the formula should be

• Real time per document = Remaining time / remaining documents, where:
  • Remaining documents = total documents - read documents
  • Remaining time = total time - starting delay - already used time
    • already used time = stipulated time for each document + delays from each document
      • stipulated time for each document = total time / total documents

So, if there is no delay, the Real time per document = stipulated time per document. But this is not what I’m getting in my spreadsheet, and I don’t know why.
Time calculation.ods (56.2 KB)

[EarnestAl]

I think I recall that the starting time from the first paper was causing difficulties but I found other issues.

• The person timing the papers has to enter the time (easy with Ctrl+Shift+;) AND make a note that it is finished (read). I made the finished mark automatic by entering a 1 and changed COUNTA to just COUNT in H18
• I don’t know if you allow overrun of time, if you do then you can see the overrun. If the finish time is fixed then you need to change B19, B29, B39, etc. from =B17+$H$23 to =B17+$H$24, etc.
• It was difficult to see the difference between time and interval so I used the existing style Hora for time of day and added Intervalo de tiempo for the differences. For ease of identification, without looking at styles, I set Hora to just HH:MM but it is easy to change.

Time calculation105799EA.ods (35.1 KB)