How to go through all the necessary cells and if the conditions are satisfied, make mathematical calculations?

Question

Macros

There is such a table, sorted by time.
how to make a script / macro to iterate through the cells and calculate such a difference - and then sum the value.
time spent in the office : this is if a sequence of pairs of values ​​\u200b\u200bis encountered, first "entrance" - then "exit"
and subtract the time corresponding to the entrances or exits between them
time spent outside the office, I calculate this if there is an exit-entry sequence, and the difference between them.

Answer 1

No macros are needed. See examples of the CountIf function. Here is the link, for example, school356spb.ru/index.php/materialy-dlya-ege-i-gia...