I hope someone can help me since I don't have the knowledge to do it.
I'm trying to build a macro that check the value in an excel cell (A) and if it is between some values it changes another cell value to a specific value, and if the value in (A) is between some other values the other cell value will be changed to another value.
It will be used to a time schedule. Let me give an example:
If startime is between 08:00 and 09:00 then breakstart it will be replaced by 12:30 and breakend will be replaced by 13:30.
If startime is between 09:15 and 10:00 then breakstart will be replaced by 13:00 and breakend will be replaced by 14:00.