[Solved] Inserting current date or time

Discuss the spreadsheet application

[Solved] Inserting current date or time

Postby Ricashea » Wed Dec 16, 2009 6:33 pm

Is there a macro or an add on that can be used to insert the current date/time into a spreadsheet cell?
Last edited by Hagar Delest on Sat Apr 03, 2010 4:57 pm, edited 1 time in total.
Reason: Tagged as solved
OPENOFFICE 3.1 ON WINDOWS XP
Ricashea
 
Posts: 1
Joined: Wed Dec 16, 2009 6:28 pm

Re: Inserting current date or time

Postby RoryOF » Wed Dec 16, 2009 7:23 pm

You can do it directly by Insert / Function / Category Date & Time
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14345
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Inserting current date or time

Postby okjhum » Sun Mar 14, 2010 5:07 pm

Thank you, but I wouldn't call this "directly", as there are several clicks to finish it. Is there a keyboard shortcut for a time stamp, as in Excel? (Ctrl+-)
I don't seem to manage to create one myself, because I only get to the "Insert function", not the function itself =NOW()
On second thoughts - it's not the function etiher, that I want, it's just the time stamp. Otherwise it will change every day...
Any help will be appreciated. /Olle
okjhum
 
Posts: 2
Joined: Sat Apr 26, 2008 6:42 pm

Re: Inserting current date or time

Postby RoryOF » Sun Mar 14, 2010 8:36 pm

There are two choices for the Insert / Fields/ Other / Date - fixed and variable; there are also formatting choices. Fixed is the time of insertion and doesn't change, variable is time of latest update. I use this so rarely that I don't know about making it into a stamp.
Apache OpenOffice 4.0.1 on Xubuntu 13.10 and Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 14345
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Inserting current date or time

Postby rwlayman » Wed Mar 31, 2010 11:42 pm

I searched on this topic but didn't find a recent post that addresses my question. I am a spreadsheet novice but I want to make an activity log Where each column is a new log entry (record) that includes about 20 rows of data entry cells. I would like the top cell of each column (record) to automatically get an absolute date/time stamp whenever any data is entered in any other cell in that column. I'ts ok if it recalculates the timestamp in the top cell each time any data is added to that column. Otherwise it should not change. In other words, it should automatically show the last date/time that any data was last entered in that particular column/record.

Its seems this would be a common need in data entry logs, so I hope someone has done a macro/formula for it.

Richard
OpenOffice 3.2.0 on Windows 7
User avatar
rwlayman
 
Posts: 2
Joined: Wed Mar 31, 2010 10:10 pm
Location: Huntsville, ALe

Re: Inserting current date or time

Postby mriosv » Wed Mar 31, 2010 11:48 pm

LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
mriosv
 
Posts: 650
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: Inserting current date or time

Postby rwlayman » Sat Apr 03, 2010 2:42 am

Thanks!

Richard
OpenOffice 3.2.0 on Windows 7
User avatar
rwlayman
 
Posts: 2
Joined: Wed Mar 31, 2010 10:10 pm
Location: Huntsville, ALe


Return to Calc

Who is online

Users browsing this forum: Villeroy and 22 guests