Questions tagged [google-sheets-timestamp]

Use for question about inserting a date, time or a date and time (timestamp) automatically into a Google spreadsheet.

Filter by
Sorted by
Tagged with
3
votes
1answer
3k views

Why would this Google Spreadsheets onEdit script be so slow (2 secs to change cells, 3 secs to update)

I've put together a script for a spreadsheet based on what I have seen here and other sources that should provide a simple username and timestamp function. I have another spreadsheet that uses a very ...
0
votes
1answer
2k views

Timestamp for columns B & D? [duplicate]

Found this script on one of the questions answered in the forum but I don't know enough to make it work. I would like it to time-stamp date and time in column B when they check in and then a separate ...
1
vote
3answers
4k views

How to show the ten most recent rows from another sheet's timestamp?

In one sheet A I have an ongoing number of rows where the first column is a timestamp in ascending order (more recent entries at the bottom). I'd like to have another sheet B where only the ten most ...
2
votes
1answer
930 views

Script gives 1899 for the timestamp year. How to fix it?

The following code was almost exactly what I was looking for to timestamp the adjacent cell after being edited. However, I need to incorporate the currnet date as well as time. The code below gives a ...
6
votes
3answers
24k views

Auto date insert when opposite cell is populated

I am creating a spreadsheet which will contain records of my daily expenditure. Something like the following: A | B ---------- 0 | 50.04 0 | 20.00 0 | 19.99 0 | 2.40 What I am trying to achieve ...
43
votes
3answers
101k views

Auto-updating column in Google Spreadsheet showing last modify date

Trying to figure out a way to have column two auto-update to show a timestamp of the last update. I realize the doc shows a timestamp of the last modification, but we have a lot of clients accessing ...
31
votes
6answers
130k views

How can I automatically set “last updated” cell in row Google Docs Spreadsheets?

How can I automatically set "last updated" cell in row Google Docs Spreadsheets ? I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
5
votes
1answer
39k views

Google Spreadsheet Timestamp? [duplicate]

I'm looking for some help with my Daily Work Log spreadsheet. I've search and read many different version of making a "TimeStamp" in Google spreadsheet. And it seems I don't have enough experience for ...
3
votes
3answers
8k views

Parsing timestamp in Google Sheets with script

I have a spreadsheet with a form that timestamps every time the form is submitted. I'm writing a script to change the background color of the timestamped cell if it is more than seven minutes after a ...
39
votes
4answers
75k views

Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 ...
38
votes
11answers
149k views

Is there any way to create a timestamp in a Google Spreadsheet?

I use PSPad as a text editor, which allows you to press Alt + D to insert a timestamp, e.g.: 2010-07-17 23:45:44 Is there a way to do this in a Google Spreadsheet?

1 2
3