CALC: Help needed for a macro to capture time in calc.

[gundabk]

Hello All,

I am new to openoffice since i migrated a few days back. I am at my wits end since calc is very different from excel. Here is brief points on what iam trying to do in the macro:

1) i have two buttons "Start" and "End".
2) when start is clicked it should print time and when end is clicked it should capture the time.
3)when again start is clicked it should capture time in next cell i.e. in the below cell without deleting or updating the time in the before cell.
4) same is the case with End button.

Your help would be appreciated very much.

@Moderator, if this is the wrong thread to post kindly point me to the original post.



Moderation probe1: moved to MACROS AND API section, where all macro related questions belong to; edited subject
_________________
Gundabk.

[davidh182]

There are several stages: including java, permitting macros to run, setting a button to launch a macro, searching for an empty cell using while()
The code to set a time in a cell is:

[gundabk]

Thanks davidh182,

I tried to execute but got error saying Error ....... it is not optional.

_________________
Gundabk.