A time and Date Formula

I found the workbook object but how do I go about pasting your code in there?


EDIT* I found the object and pasted the code. But I am unable to save the template with the formula in there. I am having to go back into the template and redo the formula.

The easiest way without having to go through manually opening up the VBA editor is to right click on the small Excel icon in the upper left of your spreadsheet next to the File dropdown menu. One of the options should be "View Code" Clicking on that will automatically put you into the "This workbook" code window in VBA. How's that?

In order to make changes to the template, open it without enabling macros. So add your code, save the template, reopen the workbook but do not enable macros, then enter your formula again and resave it. Did that work?