Excel - inserting system time seconds

[monkski]

Im using ctrl + : to insert a static system time into a worksheet, but I can only get it to insert hours/ minutes. Is there a way of including seconds? (it currently rounds down to the previous minute).

thanks

 

[psarros]

Use the function =now()

That will give you seconds .... you will then need to copy and pastse special - choose values.

You can write a macro that will do all this and assign a shortcut key..

 

[monkski]

Fantastic - thanks for your help