Google Sheets – How to Auto Update Current Time Cell

I do not think you need a script.

I think you need a formula that looks at the difference between the value in D3 and the value of =now()-today() .

in you set E1 = now()-today() - d3

then you want something like

D1 = if( E1 < 0.20, "", (if E1 < 0.05, "20 MIN", ..... etc.

(I'm pretty sure that there are easier ways to build a complex if/then/else forumla for a cell, this gives you the general idea.)

This can be done with a script, using insertSheet method which takes the new sheet name and the template after which it's to be created. The first function adds a custom menu item when the spreadsheet is opened, the second performs duplication when that menu item is invoked.

As far as I can tell, the contents are copied over in the same way as they are with "Duplicate" function.

function onOpen() {
  var menu = [{name: "Duplicate and name", functionName: "dupName"}];
  SpreadsheetApp.getActiveSpreadsheet().addMenu("Custom", menu);
}

function dupName() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var name = Browser.inputBox('Enter new sheet name');
  ss.insertSheet(name, {template: sheet});
}