Skip to content

Instantly share code, notes, and snippets.

@uneasyguy
Created April 9, 2019 02:07
Show Gist options
  • Save uneasyguy/9470eda20e0b8df524ef48ade6d252c6 to your computer and use it in GitHub Desktop.
Save uneasyguy/9470eda20e0b8df524ef48ade6d252c6 to your computer and use it in GitHub Desktop.
Google Sheets Function to update time
function update_time() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var ss = sheet.getSheetByName('Sheet1');
var formattedDate = Utilities.formatDate(new Date(), "UTC", "MM-dd-yyyy HH:mm:ss");
var merge_range = ss.getRange(3,3,3,3).merge().setHorizontalAlignment("center").setVerticalAlignment("center").setFontWeight("bold").setBorder(true,true,true,true,null,null,"black",SpreadsheetApp.BorderStyle.SOLID_MEDIUM).setFontSize(25);
var input_range = ss.getRange(3,3).setValue(formattedDate);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment