Forum Discussion

Per Almgren's avatar
Per Almgren
Copper Contributor
Feb 09, 2019

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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

Resources