Re: formula cell hide and unhide
Here's an option (sorry, I'm not good enough at VBA to write it):
User Option 1: If user chooses to input the start time and end time, then the cell that contains the formula that calculates total hours could be locked upon entering the values into those two cells.
User Option 2: If user chooses to enter the total hours, then, upon clicking the Total Hrs. cell, a message box will pop-up telling user something like, "If you enter a value in this cell, you are opting not to enter a start time and end time. Do you want to proceed?" If user chooses Yes, then user is allowed to enter a value into the cell, and the start time and end time cells would be locked automatically. This would prevent user from entering conflicting start and end times whose difference do not equal the total hours amount that user entered.
Hope that helps... If any of that is even feasible...