How do I read real time (including seconds) from the computers clock and store it in an Excel sheet

Copper Contributor
How do I read real time (including seconds) from the computers clock and store it in an Excel sheet ? I know it is available since it is displayed when pressing an area (right-down on the screen) that shows date and hours and minutes but not the seconds .
1 Reply

Hi Per,

 

You may use NOW() function and format the cell as yyyy-mm-dd hh:mm:ss (use Ctrl+1 and Custom format)

 

Please see attached