Forum Discussion
Per Almgren
Feb 09, 2019Copper Contributor
How do I read real time (including seconds) from the computers clock and store it in an Excel sheet
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
- SergeiBaklanDiamond Contributor
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