I
IF Help
Hi Guys
Im using the following formula to evalute a time period and determine if it is on-peak or off peak....
=IF(AND(HOUR(C2)>MIN($A$1,$B$1),HOUR(C2)<=MAX($A$1,$B$1),HOUR(D2)>=MIN($A$1,$B$1),HOUR(D2)<=MAX($A$1,$B$1)),"on-Peak","off-peak")
It works great if it is a proper on or off peak period. (Starts stops with in the time range). How can I modify to detemine if the period spans the the 2 periods ie., starts off peak ends on peak or vice versa, and returns "Check" if so.
Thanks a ton
Steven
Im using the following formula to evalute a time period and determine if it is on-peak or off peak....
=IF(AND(HOUR(C2)>MIN($A$1,$B$1),HOUR(C2)<=MAX($A$1,$B$1),HOUR(D2)>=MIN($A$1,$B$1),HOUR(D2)<=MAX($A$1,$B$1)),"on-Peak","off-peak")
It works great if it is a proper on or off peak period. (Starts stops with in the time range). How can I modify to detemine if the period spans the the 2 periods ie., starts off peak ends on peak or vice versa, and returns "Check" if so.
Thanks a ton
Steven