Google-sheets – Timestamp format with carriage return

google sheetsgoogle-apps-scriptgoogle-sheets-timestamp

I have this time stamp format:

var timestamp_format = "yyyy-MM-dd HH:mm:ss";

Which produced a result like:

5/25/2019 10:52:43

but I would like to have a carriage return between the date and time for this result:

5/25/2019 
10:52:43

How might I make that happen?

Best Answer

Sometimes, guessing just works!

var timestamp_format = "yyyy-MM-dd\nHH:mm:ss";

Related Solutions

Google Sheets – How to Parse Date and Time in Specific Format

Maybe:

=left(A1,10)+mid(A1,12,8)

Google-apps-script – How to add an automatic “last edited” timestamp and the user who edited entry to Google Docs

Yes, there is. Use file.lastModifyingUserName and file.modifiedDate.

Example:

function lastEdited() {
  var doc = DocumentApp.getActiveDocument();
  var id = doc.getId();
  var file = Drive.Files.get(id);
  var footerSection = (doc.getFooter())?doc.getFooter():doc.addFooter();
  footerSection.clear();
  var userName = file.lastModifyingUserName;
  var date = file.modifiedDate;
  var text = '[Last edited by ' + userName + ' on ' + Utilities.formatDate(new Date(date), 'GMT+5', 'YYYY/MM/dd hh:mm') + ']';
  var p = footerSection.insertParagraph(0,text);
  p.setAlignment(DocumentApp.HorizontalAlignment.RIGHT);
}

NOTES:

To use the above script you should enable the Google Drive Advanced service as is described in - https://developers.google.com/apps-script/guides/services/advanced

References

https://developers.google.com/apps-script/guides/docs

Best Answer

Related Solutions

Google Sheets – How to Parse Date and Time in Specific Format

Google-apps-script – How to add an automatic “last edited” timestamp and the user who edited entry to Google Docs

Related Topic