Home

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

Highlighted
Visitor
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
Highlighted

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

Related Conversations
Advice please
dandc910 in Excel on
1 Replies
Formulas Excel assistance
DEAF_DWJr98 in Excel on
4 Replies
Rearrangement and initials.
Ocasio27 in Excel on
3 Replies
Page vs Image Scaling
DarylA in Excel on
0 Replies
return max in date range based on X column #
mryno in Excel on
1 Replies