Did you know?

I am a person who keeps track of various things in spreadsheets. I have spreadsheets for my budget, gas log, fitness log, and paycheck information to name a few. I blame attribute it to my college adviser. He did practically everything in a spreadsheet. He even figured out the heat constant of his house in a spreadsheet.

I’m getting off track here. Back to the topic at hand. On several of my spreadsheets, I have columns for dates. And at work, I have a spreadsheet keeping track of when I start and stop working on a task. At my old job, our timesheet spreadsheets had a macro that would insert the date and time for you. I really wished I could find that macro so I could use it on my spreadsheets.

Well, I found out today that I don’t need a macro to do it. It turns out that [Microsoft] Excel has that functionality built into it. I didn’t know that. But I do now. And so do you. Here goes.

To insert the current time into a cell in your spreadsheet, you just have to do Crtl+Shift+; (be sure to hold them down all at the same time and go in that order.)

To insert the current time into a cell in your spreadsheet, you just have to do Crtl+;

You can use both in the same cell too, just do the date then hit the spacebar and then do the time. Easy as that.