Calc: Timecondition - automatic hour-calculation from changing 24hr-clock (ex. 16-9 from which 16-24 =8 and 00-9 =9), with additional 2-4 changing conditions of which one is the date-cell

Thank you Horst for this suggestion. Are you too able to check the ods? It doesn’t matter whether it is numerical or text - the simpler and easier manageable the better. I really don’t know how to best make it. I would appreciate it, if you can evaluate what you told before again against the uploaded *.ods-file.