Timestamp - 1106 - Learn Excel from MrExcel Podcast

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Sep 22, 2009.
David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today tip sent in by David from Australia and I think I've shown this on the podcast before, but it's worth repeating, because it's a cool little trick.
First of all, let's talk about the function called Now.
=now() is an interesting function, that it puts in current date and time.
So if you use Now, you might be interested in a function called =today.
Today is like Now, except it doesn't bother to put in the time, that's nice as you calculate the spreadsheet, that calculations not going to change.
But what if you want a date and time that isn't going to change?
That's just going to be permanent, not the current date and time, but the time that you happen to enter the date in the spreadsheet.
A couple of cool tricks here that David sent in.
If you just press Ctrl+; that will put a current timestamp right in the cell.
Ctrl+; and then Ctrl+Shift+;, which is basically doing Ctrl+;, will give you the current timestamp.
Great little trick there, the way to remember it of course, in time we have a colon, so it’s Ctrl+; to get the time, just unrelease the Shift, Ctrl+; to get the date.
Thanks to David for sending that question in, thanks to you for stopping by, we'll see you next time for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top