2

I want to know is there any formula except =NOW() to insert time in an excel sheet also which should not update time automatically?

The formula =NOW() is working fine but the problem is that it is updating time automatically with system's clock. I want there should be any formula or method which should free the current time when once inserted.

1

4 Answers 4

5

Why use a formula if you don't want it to update automatically? Just enter the date directly into the cell. A shortcut to enter today's date is Ctrl+; (semicolon).

1

I've used a lot of circular formulas to do just this. The cell will populate when another cell is updated, but if the cell is already updated, it references itself (circular). When you turn on circular formulas in excel it also asks you how many times it should iterate, I think the default is 100 but you can lower that if you need to.
Short tutorials to explain:
http://www.howtoexcelatexcel.com/excel-tips-tricks/create-a-timestamp-in-excel-with-formulas/

0

To have the value of =NOW() frozen in time, after entering the formula in a cell, just copy and paste it over itself with Paste Values enabled (access the Paste Special dialog with CtrlAltV after pasting).

3
  • dear friends @Mark Wallace,I know that ctrl+shift+; enters current time in the selected cell but i want some formula for this as my purpose is something different. please help...
    – ramji
    Oct 19, 2015 at 13:33
  • dear @Andre Neves,,I know that ctrl+shift+; enters current time in the selected cell but i want some formula for this as my purpose is something different. please help..
    – ramji
    Oct 19, 2015 at 13:33
  • dear @bdr9, ,I know that ctrl+shift+; enters current time in the selected cell but i want some formula for this as my purpose is something different. please help..
    – ramji
    Oct 19, 2015 at 13:33
0

Further to bdr9's correct answer, Ctrl+Shift+; inserts the time. If you want date and time, do both, with a colon/space/separator-of-your-choice between them.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .