Tip o’ the Week 396 – Handling dates in Office apps

clip_image002There are many times when you may need to deal with dates in ordinary applications – and there are a few shortcuts that you can make it easier.

In Outlook, any time there’s a date field (like when you’re setting a reminder, or clip_image004entering the start date/time for an appointment) you can choose or enter a regular date, or put in an expression – like “2 days” or “next Tuesday” – and Outlook will figure out the offset from today, and will set the appropriate date.

In some date fields (like an appointment start time), if you say “4 days” then press enter or TAB, it will evaluate the new date; if you return and put “4 days” again, it may add those extra days to the last date. Try a few other things like “next Christmas”, “3rd Sunday in November”, “2mo” , “7d” or some special days – there are some surprising ones there, like “Lincoln’s birthday”, and other events with static dates … though nothing that might change the actual date from year to year (like Easter, or Thanksgiving).

clip_image006In Excel, press CTRL+; to insert the current date into any cell – add a SHIFT key to insert the time instead. Excel are many date-oriented functions, but you don’t always need to write functions – simple maths can work on date fields – calculating the number of days’ difference between two dates, for example, or adding a number of days to a start date.

clip_image008In the desktop OneNote app, if you want to edit the date and time at the top of a page, click on the field and you’ll see a clock or calendar icon appear next to it – click on that  is set to, click on that to change the value; handy if you’re updating some reference material and want to make it clear that it’s recent.

Another way might be to insert the current date or time into the text: to do so, press SHIFT-ALT-D, or SHIFT-ALT-T for the current time, or SHIFT-ALT-F for the current date and time. The last one is really handy if you’re taking notes about a phone call, and want to quickly note the time that your insurance company said that everything was all fine, or when you started the indefinite call to the airline. The same shortcuts apply to the desktop OneNote 2016 application and also the OneNote store app.

clip_image010Word also supports SHIFT-ALT-D and SHIFT-ALT-T like OneNote, though inserts a date or time field rather than a simple bit of text, and is slightly different to the Date & Time command on the Insert tab, which gives a bit more control over the formatting at the point of insertion, rather than requiring the user to insert the field then go back in to edit the format.

Since Outlook uses Word as its text editor behind the scenes, the same shortcut keys will also insert date fields into the text of an Outlook email.

Tip o’ the Week #325 – your time, my time, everyone’s time

clip_image001Time is a subject that features regularly on ToW (tick, tock, tick, tock); maybe it’s a fact of getting older that it seems to speed up, or it could just be that the IT industry has for so long sold the vision of increasing productivity, that we start to believe it too.

If we become more effective in some ways, decreasing the time it takes to accomplish mundane stuff, will we spend the regained hours doing more stuff, or just fritter it away meaninglessly? Discuss, ad inifinitum.

Quick Time

One thing you could do when deciding what to do with all the spare hours the world of Yammer, Slack, Outlook, Skype etc has delivered, is to go right now and uninstall QuickTime from your PC. After 20 years of providing the Windows version, Apple has decided (to quote El Reg) to take QT for a long drive down a country road. The US Dept of Homeland Security advises immediate removal of QuickTime, since it contains zero-day vulnerabilities which Apple will not fix, ever. Whilst thinking about security, wonder about the effectiveness of the Thousands Standing Around at US airports, or consider if you really need to change your passwords after all.

Find Time clip_image002

A few months ago, a Microsoft Garage project released FindTime, an addin to Outlook and Office365 which allows a meeting organiser to send a request out to a group of people, to vote for when the best time to hold the meeting is. The best part is, the recipients don’t need to be using Office365, don’t even need to be in the same company – so you could ask your customers to join in the negotiation for when the best time to meet would be.