if and and time

I’ll outline the situation:

I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, 8:00-11:59 AND 6:00 to 10:59 is y, 12:00-5:59 is z. date is a, time is b. the amount of energy to be multiplied by price in c.  Ive tried a number of formulas and have only gotten “false”

By: brandon

Leave a Reply

Your email address will not be published. Required fields are marked *