Easy Excel Trick: Insert Current Time

CTRL+SHIFT+; (semi-colon) – Enters the current time in the right format

How to use it?
1. Click in any cell
2. Press CTRL+SHIFT+; (semi-colon) (in Mac control+shift+; (semi-colon))

The difference betweenCTRL+SHIFT+; (semi-colon) and =now() formula is that the later will change according to the time of the day while the first will stay constant, it’s value of the time when typed.

Leave a Reply

Your email address will not be published. Required fields are marked *