Inserting time in spreadsheet

[Eiopqrtuwy]

I need some way to automatically enter the ACTUAL time and keep it from changing.

Does this make sense? And, can anyone help me?

Thanks

Excel has some keyboard shortcuts to do this:
Insert Date: Ctrl + ;
Insert Time: Ctrl + Shift + ;

Alternatively, here are two other slightly more tedious, (but more flexible) ways to turn dynamic equations into fixed values:
1) After you've imputed your equations into want "Copy" then "Paste as Values" over the same cell(s). Can be for a single cell or a range of cells.
2) While imputing an equation highlight the part you no longer want to be volatile and press "F9" (e.g. highlight the "=NOW()" in your formula bar and press "F9", then "Enter" to keep the changes.)