I need help creating a macro that will use Cell A1 (now()), the penalties (amounts of breaks) per hour listed on the penalties tab, and the input data of hours and minutes to determine a completion time.
The thing where I get confused is we have different "breaks/penalties" depending on the day of the week. I have listed all of those in the penalties tab.
The Calc form B9 and B10 are what I want to populate with the macro.
Can anyone help?
Erin:
Bookmarks