Openoffice clock through Macros in spreadsheet

Asked By alex whisler 30 points N/A Posted on - 10/09/2012

Hi

I want to display a clock in open office spreadsheet through macros. I need the code of macros for Open office clock through. If someone has then give me the macros code.

• Status: Open
• Question Views: 1016
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Page Layout Software

Answered By Nicke Baker 0 points N/A #158787

Openoffice clock through Macros in spreadsheet

Hello Alex,

Here is a procedure to guide you through that

• First you will need to click on the cell where you want to insert your data point,  and then you will type  "=NOW()" into the cell.
• After that press the "Enter" key to save the value, and then right-click the cell containing the value you just created, then select "Format Cells."
• You will need to choose  "Time" from the "Category" column, and then select your preferred notation from the "Format" column, then click "OK.".

Regards,

Nicke

 

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 10/19/2012
• Question Category: Page Layout Software