Timeclock spreadsheet help

jamiepullen · Newbie Joined: 06 May 2012 Posts: 4

I am no spreadsheet expert, but i have cobbled the following together using bits of code from the internet:

https://docs.google.com/open?id=0B1colqQ9mrgiaXZUUGxxQldhOWM

I really need to have the following added and would love to get some help/tips/advice, or just to know if i am trying to do the impossible....

I would like that when the clock is clicked, the date is populated in column a, then the time in b. When it is clicked a second time, the time is populated in c and then it drops down to the next row, ready to timestamp for the next day.

Currently, all i have is it will timestamp the active cell.

I would also like to be able to protect the cells so that the time cannot be altered by the user. Currently, if i protect them, the timestamp will not function.

Can anyone offer some help please?

Jamie

Villeroy · Posted: Sun May 06, 2012 12:38 pm Post subject:

Very easy to do with a database. You can define a column to put a time stamp into each new row and hide that row from the user interface.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

jamiepullen · Newbie Joined: 06 May 2012 Posts: 4

This needs to run on a work computer. The only program it has is openoffice. Can i use a database to do this? if so, how? it is set so nothing else can be installed on it...

Villeroy · Posted: Mon May 07, 2012 2:11 am Post subject:

Since you do not even tell us your office version nor operating system you are the one and only person to know.
Bye
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

jamiepullen · Newbie Joined: 06 May 2012 Posts: 4

Thanks established user. That is really helpful to the thread and the forum.

'Welcome to the openoffice community' it said when i first used it.

Unless i have misunderstood the German/English translation, you have just politely asked a new user of openoffice to go away and stick to excel?

Enjoy the forum, i see you post often. Perhaps if you used your attention to helping, rather than showing off that you know more, it would help the forum.

Or like i said, maybe it is in the translation?

I am off to seek help elsewhere, or try another method. Or maybe i just havent found the openoffice community yet to help with what i thought was a perfectly sensible question.

Anyone googling my question will find things like this and be put off of joining the forum for fear of answers like this. As a newbie, i did not know that OS or version made a difference to spreadsheets.

I do now.

Bye

jrkrideau · Posted: Tue May 08, 2012 8:00 am Post subject:

Villeroy · Posted: Tue May 08, 2012 4:47 pm Post subject:

A database that saves an automatic row number and a time stamp for each entered integer number:
http://user.services.openoffice.org/en/forum/download/file.php?id=3048
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

jamiepullen · Newbie Joined: 06 May 2012 Posts: 4

Thank you, I will take a look.

Jamie