Formulas for Irrigation Zone Start and End Times

Hello,

Can some please come up with formulas for the irrigation schedule to post the times that each zone runs.

Zones will run on selected days with an "X".

Each day start time is determined from cell B6. So the first zone that is enabled for that day will start at the time in B6.


The time between the zones is determined from cell B4. So that is the time between the End Time from the previous zone to the Start Time of the next zone.



Formulas are needed in the range I15:V29 please.


A few examples were manually entered with the desired results.


Thank you very much for your help

Take a look here .....

https://www.excelforum.com/excel-for...end-times.html

Try the following ...

in I15

=IF(INDEX(Intersect_X,MATCH(I$13,$E$5:$E$11,0),MATCH($D15,$G$4:$V$4,0))="x",$B$7+(COUNTIF(OFFSET($G$5,MATCH(I$13,$E$5:$E$11,0)-1,0,1,MATCH($D15,$G$4:$V$4,0)),"X")-1)*1/24,"")

in J15

=IF(I15="","",I15+$F15/1440)

Copy both down

then copy/paste both columns to other days

There is probably a "smarter" way with 365 functions!