593 – It’s a Date

Posted on August 27, 2021 by ewand

Following last week’s missive on Notepad, including the obscure tip on how to create a log file, the topic of inserting and handling dates in other applications is worth a (re-)visit. Each individual app may choose to offer different methods and formats, but for common Office applications there are a handful of memorable tricks and shortcuts.

In Word, there are plenty of ways to insert and manage dates – perhaps the most useful way to remind the reader when the document was last updated (manually showing when a document was last reviewed or published). On the Insert tab, you’ll find Date & Time on the right-hand side, letting you add appropriate info in the format of your choice. You can also tick a box to update the field automatically, though that simply means every time the document is opened, it will show today’s date… which feels a bit pointless.

More useful could be to tell the reader when the document was created or last saved, by referencing the actual properties of the document (though be careful; auto-save might mean someone opened an old document, realised it was irrelevant, but had inadvertently saved it back).

On the Insert tab / Quick Parts, look under Field, then pick the doc property and format you’d like to show.

It is worth pointing out that showing a date as 10/1/21 (or similar) is ambiguous given that a few hundred million people will expect it be month-day-year while many of the remaining 7 billion will assume the day comes first, with a couple of billion presuming the format should normally start with the year, such as yyyy-mm-dd (which is arguably the most sensible of all; and it sorts properly, too).

A more daily usable short format like dd-mmm-yy (ie 13-Aug-21) should perhaps be the norm, especially when the date is appearing as text in a document. Pressing SHIFT+ALT+D in Word will insert the current Date as a field (so you can edit the format to remove ambiguity) and SHIFT+ALT+T inserts the current time too. In PowerPoint, both of these combos bring up the “Date & Time” dialogue to add the chosen content and format as plain text.

When formatting dates, incidentally, the convention is that two letters refer to the short number (eg dd = 13), whereas 3 d’s or m’s will use the short form of spelling the day or month, with 4 meaning the whole thing (ie Friday, August). Try formatting a cell in Excel as Custom, and you can preview what the format would be, by typing in a variety of letters.

While in Excel, it’s worth learning the short cut key to insert the date and time – CTRL+; and SHIFT+CTRL+; respectively (no doubt there’s a reason why Excel has a different shortcut to other Office apps – some legacy of Lotus 1-2-3 perhaps?).

OneNote fans will want to remember that SHIFT+ALT+D / T combo as it inserts the date/time into the notebook; really handy when taking notes of a phone call or similar. SHIFT+ALT+F puts both day and time, something that Word doesn’t offer. In both Desktop OneNote and users of the Windows Store version, it’s just plain text that gets added, so you’re on your own when it comes to formatting.

OneNote pages will typically have a date & time showing under their title – on the Desktop version, it’s possible to change that so as to mark a page as having been recently updated. No such luck on the lame duck Store version.

At least when stalwarts insist on writing – or worse, saying – a short-form date as something like “ten one”, there’s more than half of each month where one number in the date could only mean “day” – starting with the thirteenth (as in, 8/13 can never by the 8^th of a month, but 8/12 could be a few days before Christmas to Europeans, or the date when tweedy Americans start looking for grouse in the Yorkshire moors and Scottish Highlands).

#571 – Save the Daylight

Posted on March 12, 2021 by ewand

In the Northern Hemisphere, spring feels finally underway – and following a long locked-down winter, it can’t come soon enough. For many of us, even if meteorological spring started nearly 2 weeks ago, the promise of summer starts when the clocks go forward to daylight saving – or summer – time.

If the country or state you’re in observes summer time, then you’re either about to enter (if in the northern half of the marble) or leave it (if southern). To keep us on our toes, this movement back or forth often happens around the world on different dates. To keep us on our toes, some countries have less-than-hour gaps between time zones, and in the past, others have decided to change time zone permanently.

In olden days, some people wore GMT or World Time watches, which allowed the user to tell what the time was in different locations. With the World Time example here, the red arrow hand points (on a 24hr scale) to the current time; when the user rotates the outer bezel so that the nearest location is pointed to by that hand, the other locations listed on the bezel will be aligned with the 24hr number of the current time in those places…

– eg if it’s 2:30am in Iran, then lining Tehran up with the red hand would put both London and Paris at midnight, since they’re both at GMT+1.

eh? In October 1968, the UK decided to move to British Standard Time – GMT+1 – all year round. This particular wristwatch was produced between 1968 and the end of 1971, when the practice was reversed – so for a while, it was correct that London would be in the same time zone as Paris and Rome. Except the watch wouldn’t know when Paris and Rome went into summer time, thus putting them an hour further ahead… oh well, never mind.

There may be trouble ahead

In a global working environment, especially one where everything is done online rather than having people in the same location, the friction of time zones changing has never been more obvious. Usually, you’ll only move through time zones relative to everyone else when you travel – flying across large distances, or maybe just driving across a bridge or dam.

But now, a digitally-oriented meeting can shift its time for some of its attendees, relative to the others – depending on where the originator is based.

The excellent Alarms & Clock app, which is part of Windows 10, lets you pin cities around the world to a map, showing their approximate location (bet you didn’t know Brissie was south east of Sydney?) and what the time is currently, and if you click the Compare icon to the left of Add new city, you’ll see a grid indicating the relative time in all of your pinned cities. You can jump to a specific date, so if you’re planning a meeting with people in different time zones, it might be a good idea to check what the impact of Daylight Saving Time (DST) changes might be.

Those parts of the US which observe DST, are due to move an hour forward this coming Sunday (ie March 14^th). In common with doing things differently to everywhere else, that brings the US (and Canada) one hour nearer most of Europe for the next two weeks, until the end of March. Much of the southern hemisphere comes out of DST the week after that, so by then Sydney will be two hours nearer London than currently.
More info.

The impact of this can be seen in peoples’ calendars, when regular meetings somewhat inexplicably start to clash with each other – if a UK organiser set a recurring meeting for 4pm GMT, that would normally compel Seattleites to be there at 8am, but since they’ll be only 7 hours behind for a couple of weeks, that shifts to 9am in their calendar, potentially clashing with some existing 9am Pacific Daylight Time meeting.

Conversely, a 9am PST / 5pm GMT meeting as created by the person in the US a few weeks ago, would now start at 4pm in the afternoon in London. Great news if that meeting is a Friday afternoon, as it brings beer o’clock one hour forward.

Although Outlook does a pretty decent job of juggling the differences between time zones, there is no obvious way to show what time zone a meeting had been created in (eg show me all meetings that are going to be affected by this shift for the next 2 weeks). A simple trick if you want to check on a specific meeting, is to start a Reply to a meeting you’ve been invited to, whereupon you’ll see the time zone of its creator…

—–Original Appointment—–
From: originator

Sent: 14 February 2021 08:03
To: people

Cc: more people

Subject: meeting that could have been an email
When: 12 March 2021 08:30-09:00 (UTC-08:00) Pacific Time (US & Canada).
Where: Microsoft Teams Meeting

While It won’t help you identify the meetings that are causing the clashes, it might help restrain you from firing angry missives at the organiser of the meeting, if you know what’s causing it.

551 – Ticking away the moments

Posted on October 9, 2020 by ewand

Keeping track of time is ever-present in our normal working lives, all the more so during These Difficult Times™, and the subject has featured in many ToW’s passim.

There’s a great little app built-in to Windows 10 called Alarms & Clock, which lets you set alarms on your PC, show a world map with multiple locations / time zones displayed, and also provides a neat countdown or count-up timer.

Using the timer function can be pretty handy if you’re speaking as part of an online meeting, and need to keep a check on how long you have left to go.

You can create multiple separately-controlled timers with different durations & names; so you could have an overall meeting countdown timer, and then a separate one for each participant, if you were acting as the time cop to keep everyone else in line.

The Stopwatch is simply a fast-running counter of elapsed time, and by using the icon on either Timer or Stopwatch screens, you can easily fill the display to help focus on the elapsed or remaining time. Handy if you’re in a physical meeting (remember them?) and are able to display a laptop screen showing the time for everyone.

Those of us who still wear physical, mechanical wristwatches may be passingly familiar with a few features that have existed for decades to achieve the same kind of function, albeit more for individual rather than shared use.

Diver bezel

So called “diver” watches were popularised in the 1960s and 70s, as tough, waterproof and utilitarian. The most striking feature of any dive watch is generally the rotating numbered bezel which goes around the outside.

The simple idea was that when you entered the water (knowing you might have 20 minutes of air), you would turn the bezel so the arrow / zero marker was set to where the minute hand was at that point – meaning a later glance at the watch will tell you how many minutes have passed since.

Lots of other non-dive watches also have rotating bezels or indicators, and can be useful for things other than scuba – when the activity above started at 5 minutes to 10, the bezel was set, and it’s easy to see in a trice that was 11 or 12 minutes ago. Not sub-second accurate, but it’s a simple way to mark the passing of time.

Tachymetre /Tachymeter

Many chronograph watches – which combine the function of a stopwatch and a regular timepiece – have a Tachymetre scale around the outside, yet most people these days will have no clue what it’s for. The basic function of the watch is that pusher buttons on the side will start and stop the movement of the chronograph hand which ticks round to indicate elapsed time.

The deal with the TACHY scale is that if you know a distance – the length of a straight on a motor-racing track, for example – and you time something going over that distance, then you can quickly calculate its speed across the ground.

In practice this is easier said than done, since the TACHY scale reads how many of the <distance> would be covered in an hour at this speed. If the measured distance was exactly 1km or 1mile then it’s an easy calculation – if it took 12 seconds to cover 1km, that would equate to 5km per minute or 300km/h. If the measured distance was a fraction – let’s say the length of the 12-second straight was 150m – then the calculation would be 300 x 150m per hour, or 45km/h. By the time you’ve done that in your head, the subject will be half a lap further on…

Another variant on the theme would be if you know the speed – e.g. you’re in a plane with inflight map display, or passenger in a car on cruise control on the motorway – then you could use the Tachymeter to calculate distance travelled.

If you were cruising at 120km/h, and started the timer, then stopped it when it reached 120 on the scale… (after 30 seconds) – then you know you will have travelled 1km in that time.

Yes, there probably are hundreds of times a month when you need to know exactly this.

Pulsations

Slightly more useful to the average person, some chronographs have a Pulsations bezel rather than a Tachymeter scale, or maybe even have both (since the Tachymeter would typically be used for more than 15 seconds, it’s possible to have one quarter of the bezel represent pulsations and the rest of it be a Tachy).

Watches with Pulsations bezels are sometimes nicknamed “Doctors’ watches” as the utility is to help count a patient’s pulse – the method being you start the chronograph, count 15 pulses and the corresponding number on the bezel would tell you what the pulse/minute rate is.

Smart watches, eh, who needs them when you have space-age timing technology like this?

539 – Outlook calendaring fun

Posted on July 17, 2020 (Updated August 7, 2020) by ewand

Pretty much everyone who uses the Office productivity suite probably relies on Outlook for not just the daily splurge of email, but for organising their activity either by tasks, flags or just putting stuff in their calendar.

Here are a few simple tricks to remember when working with your calendar:

You can move to Calendar in Outlook by pressing CTRL+2 anywhere in Outlook – if you’re trying to organise meetings for lots of people and need to keep flicking between mail and calendar views, this can save you so much time (CTRL+1 for mail, CTRL+3 for contacts etc – try the rest of the numbers out for a trip down memory lane). Even the clunky old Notes function in Outlook now synchronises with Sticky Notes.
CTRL+T always takes you to Today, or if you have the Ribbon showing, you can click Today there – though an update to Calendar’s UI which was shipped to M365 subscribers in March, also added a Today button at the top left of the main calendar view, as well as a few other tweaks.
CTRL+G launches an old-school dialog that lets you jump to a specific day – and lets you choose from a date picker, or type the date in if you prefer. Like lots of other old-school date dialogs in Office apps, you can enter certain natural language phrases too – some like next month, 3 weeks, will be relative from today’s date, others like June will take you to today’s day in that month (try it out; it’s easier to see than to explain) and there are certain special days like Christmas where it will jump to the next occurrence. See ToW #291 from nearly 5 years ago for more date tips. For multi-lingual dates and other stuff, see here.
Manage Time Zones – at this time of year, some of us would ordinarily be planning holidays involving travel to foreign climes, but not so much in 2020. There’s every likelihood of planning online meetings in other time zones while you’re sitting in your own office in the middle of the night – so it’s worth adding multiple time zones to your Outlook Calendar view and labelling them. Right-click on the time bar to the left of your calendar view, and choose Change Time Zone to manage the display of time zones, or even switch your whole PC between them quickly.
The rather nice Windows 10 Alarms & Clock application (WinKey+R then ms-clock: if you don’t like to click) has a nifty display of multiple time zones if you like to see at a glance where and when everyone is.
Colour-coding appointments is another favourite tip the super-organised use. You can right-click on any appointment to colour it by setting a Category, or you can use Conditional Formatting on a view to colour appointments based on category – like who sent it, or what location it’s in, etc. See more here.
If you’re feeling extra-brave, you could install a special form that lets you differentiate mail – and therefore, appointments – which originated from an external source, by exposing a hidden property. This allows you to automatically colour them differently.
Delve into ToW #275 to install the form, then set up a Condition under the Calendar view in much the same way.

Tip o’ the Week 489 – What’s the time?

Posted on July 19, 2019 (Updated July 19, 2019) by ewand

The subject of time has featured on a few occasions on ToW, but it’s always worth revisiting. After the time-centric ToW 488’s reception on The LinkedIn, it’s always possible a few more people will be reading this week, too.

50 years ago, as the countdown timer clicked zero and the biggest rocket that was ever made (and still is) was fired to the moon, one of the few bits of technology onboard that wasn’t specifically made for the program was the Swiss watch around each astronaut’s wrist.

Despite all the computing power available to them, they used the stopwatch function to time critical parts of their mission. NASA went to some lengths to choose the right watch for the purpose, and when the ill-fated Apollo 13 needed to be guided home, Jack Swigert timed the corrective burn on his Omega Speedmaster.

Back on earth and presently, on Windows 10, a single-click on the clock in the taskbar will show you the current time in multiple time zones (if you have it set up that way), as well as the date in a calendar that you can move around without worrying the PC’s own date setting. The Calendar app can sync your agenda and display that in the same view, and is a great way of quickly checking future commitments for a given date.

Many people now rely on phones or computers to tell the time, either a casual glance to see if they need to wrap up yet, or to be reminded that some activity needs to be completed. The Alarms & Clock app in Windows is a nice way of looking at the time across the world, of being reminded at a particular time, or just using a countdown timer or stopwatch to time the duration of something.

What is time?

Existentially, time is relative. If you ever find that your Windows PC isn’t keeping time accurately, you may want to check that you have it set to get its time automatically (check Settings -> Time & Language – > Date & time), or go into the old-fashioned Control Panel, search for time and look at the settings in there, especially under the “Internet Time” tab to see where it’s syncing the time from: time.windows.com is probably the default.

Windows Time is also a thing – the number of milliseconds since the machine was started up, and also the name of the service that controls the time synchronisation. Unix time is also a concept, measuring the number of elapsed seconds since 1^st January 1970, and may present another millennium bug style problem in 18 years, if anyone is still using 32-bit *nix by then.

Back to simple relativity, though – what is the actual, real “time”? If you have multiple clocks, watches, phones & PCs, it’s a fair bet that they’ll all be divergent, unless they’re all being synchronised by some external device (your broadband router, maybe). If you’d like to find out exactly what the time is and don’t have access to an atomic clock or similar, there are a few online resources that might help… and you could even try asking Cortana, as she knows about time zones and stuff.

But the best time site is http://time.is. Try it from any device and you’ll get the time right now; some allowances need to be made for network latency but the operators have tried their best. It tells you the time in your location (or one of your choice), and calculates the offset between your computer’s clock and the time.is service.

For an illustration of what latency (as ultimately governed by the speed of light) means when accessing nearby vs far away websites, check out www.azurespeed.com, which measures the time to connect to storage services at Azure datacenters. Some variance could be explained by performance spikes and so on, but the main impact is network latency due to distance travelled. The results can sometimes be surprising.

Tip o’ the Week 488 – Time Zone Travelling

Posted on July 12, 2019 by ewand

Heading somewhere nice this summer? Perhaps somewhere hot and busy, such as Las Vegas?

When moving between countries, one of the tricks the traveller needs to decide is how to handle the switch of time zone. Do you set your watch to the destination time as soon as you board the plane, or only when the pilot announces, in his or her ever-so distincive pilot tone, what the local time is on arrival?

If pilots all sound the same, what about air-traffic controllers?

Also, do you wait for your phone to pick up the destination time zone automatically, or do you set it manually? If you have a Fitbit or other wearable, do you want it to pick up the time from your phone or do you force it on departure? Decisions, decisions…

Frequent travellers tend to have pearls of wisdom on how to deal with jet lag – like get your mind in the destination time zone and keep it there (ie. If you’re out having dinner after arrival, do not keep saying that it’s really 4am; it’s 8pm now and you can’t go to bed for at least another two hours), or get the sun – or even a bright light – on the back of your knees. It’s a lot easier to handle the differing time zones using your PC…

Outlook – whenever an appointment is created, its date and time are recorded as an offset from UTC, and the time zone it’s due to take place in is also noted. If you’re creating meetings or appointments which are in a different time zone, like travel times, then it may be worth telling Outlook by clicking the Time Zone icon in the ribbon, and then selecting the appropriate TZ – especially useful if you’re moving between time zones during the appointment itself, and don’t want to run the risk of horological befuddlement.

If you’re booking a load of appointments in another time zone – eg. you’re working in another country for a few days and creating appointments with people in that locale – then it’s even worth switching the TZ of your PC whilst you do the diary-work, to save a lot of clicking around in setting the appropriate time zone specific to each meeting.

The best way to do this would be to show your second time zone in the Outlook calendar – in the main Outlook window, go to File | Options | Calendar and select the second one to show; when you’re ready to switch between your local TZ and the remote one, just click the Swap Time Zones button to switch the PC (and Outlook) between the different zones.

Windows 10 – In the Settings | Date & time menu, there’s an option to tweak how Windows deals with time and time zones – some of which might be applied by policy and therefore greyed out for you. Like phone OSes, Windows 10 has the option of setting time zone automatically.

If you’re going to use the time zone swapping in Outlook as per above, switching time zones before you actually travel, then it’s worth disabling the automatic mode as Windows can get itself properly confused; the default time zone will change, and Outlook will end up showing the same time zone for both primary and secondary.

Using the old fashioned Windows control panel time settings applet, you can choose to show a second time zone in the clock on the system tray – in the Date & time settings, look to the right and you’ll see Add clocks for different time zones.

The Alarms & Clock app in Windows 10 shows a map of the world with your choice of locations, and the moving daylight line so you can see what’s happening around the globe. A good alternative to that exec boardroom display nonsense, that you might expect to see gracing the wall of your average corporate hot shot.

Tip o’ the Week 419 – What’s the time?

Posted on February 23, 2018 by ewand

The subject of time has featured on a few occasions on ToW – #301, #314, #325, #388 … but there’s always more scope to talk about it.

Windows 10 tweaked the way time is presented, from showing the calendar and the agenda (sourced from whatever is synced into the Calendar app), to the Alarms & Clocks app which offers visual wakeup alarms, daylight maps, and timer/stopwatch apps.

In the Windows Insiders builds of the last few weeks – currently 17101 (which is now in the Fast Ring), there have been changes that bring the clock further forward too – the Game Bar has been updated to include the clock on the left of the bar, for one thing.

What is time?

Windows Time is also a thing – the number of milliseconds since the machine was started up, and also the name of the service that controls the time synchronisation. Unix time is also a concept, measuring the number of elapsed seconds since 1^st January 1970, and may present another millennium bug style problem in 20 years, if anyone is still using 32-bit *nix by then.

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

Posted on September 19, 2017 by ewand

There 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 entering 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”, “3^rd 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).

In 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.

In 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.

Word 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

Posted on April 29, 2016 by ewand

Time 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

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.