The following excerpt is taken from Chandoo’s blog on time and date functions. It’s just a bookmark post. All credits to him.
Staying at present:
- To have latest star date in a cell, just press CTRL+; (of course, in Excel world, star date is nothing but whatever date your computer shows)
- To have current time in a cell, just press CTRL+:
- Of course, we time travelers are lazy.