Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow.

Calculating Total Working Days (NETWORKDAYS)

Calculate the difference between two dates, exempting the weekends and holidays, using =NETWORKDAYS

Using NETWORKDAYS function:

  • Format: =NETWORKDAYS ( date1, date2, holidays)
  • date1 must be the earlier of the two dates.
  • holidays is an optional argument

Cheers!

hɔuᴉnb

Additional reading:

Comments questions (and magik tricks) are always welcome!

Hidden Excel: Find Date Differences with DATEDIF

In honor of the 40th anniversary of J.K. Rowling’s seminal classic, Harry Potter, this post magically exposes a hidden excel function!

Date Difference between J.K. Rowling’s Birthday and Harry Potter Movie Debut

Ever wonder if your spreadsheet is keeping something from you?

DATEDIF is an under-documented function. It allows  you to calculate the difference between two dates. Although it doesn’t appear in the Function Wizard (it exists to insure backward compatibility with Lotus and earlier Excel versions) it is a powerhouse when it comes to calculating date differences.

Using DATEDIF function:

  • Format: =DATEDIF ( date1, date2, “interval”)
  • date1 must be the earlier of the two dates or an #NUM error is returned.

Interval Arguments:

y Years
m Months
d Days
ym Months, years excluded
yd Days, years excluded
md Days, years and months excluded

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Speak Thai, Latin and Arabic with Excel.

ROMAN-Starwars.gif

Ever wonder what your birthday looks like expressed in roman numerals? Want to display your travel expenses using Thai?

BAHTTEXT.gif

Use these functions to convert numbers to their respective lingo.

Formula Description Example Result
BAHTTEXT Converts number to Thai text =BAHTTEXT(451) สี่ร้อยห้าสิบเอ็ดบาทถ้วน
(Four Hundred and Fifty-one)
ARABIC Convert Roman Numeral to Arabic =ARABIC(MCDXCII) 1492
ROMAN Convert Number to Roman Numeral =ROMAN(1984 , [0] )* MCMLXXXIV

*ROMAN, has an optional argument, format . When format is included, the number is expressed differently, ranging from classic (0) to simplest (4). When this argument is omitted, the classical format is displayed.

Cheers!

hɔuᴉnb

Additional reading:

Comments and questions are always welcome!

Google Maps: Location Sharing📍

Google Location Sharing2.gifNEW: Google Maps Location Sharing, available to those with and those without Google accounts, enables you broadcast your location to those you choose.

Used in connection with  Maps’ Directions feature (aka, Drive mode) you can automatically send updated ETA information, so loved shared ones will know whether you’re stuck in traffic or have dropped into the pub for a pint.

Share your location with other Google account users…

  1. On your phone or tablet, open the Google Maps app Google Maps.
  2. Tap Menu Menu and then Share location and then Add People Add people.
  3. Tap Select People.
  4. Choose who you want to share with and for how long.
  5. Tap Share.
..or with those that do not have a Google Account
  1. On phone or tablet, open the Google Maps app Google Maps.
  2. Tap Menu Menu and then Share location.
  3. Tap More More and then Copy to clipboard.
  4. Using preferred messaging or mail app, paste link and send to intended recipients.

To stop sharing your location

  1. Open the Google Maps app Google Maps.
  2. Tap Menu Menu and then Share location.
  3. Tap Remove next to shared person to Remove.

To share your ETA

After you start your drive, you can share your destination, estimated arrival time, and where you are on the route.

  1. Open the Google Maps app Google Maps.
  2. Set a driving destination.
  3. After you start navigation, tap More and then Share trip progress.
  4. Choose a person from the list.
  5. Tap Share.

Location Sharing will stop when you reach your destination or stop navigating. To stop sharing before you arrive, tap More  and then Stop sharing.

See where someone is

If someone shares their location with you, you can see them on the map.

  1. Open the Google Maps app Google Maps.
  2. Tap Menu Menu and then ​Share location. Location sharers will appear as icons.
  3. Select person; the map will adjust to display their location.

Stop seeing someone’s location

  1. Open the Google Maps app Google Maps.
  2. On the map, tap sharer’s icon.
  3. At the bottom, tap More Up arrow.
  4. To temporarily hide someone, tap Hide from map.

Cheers!

hɔuᴉnb

Related posts:

 

BMW LINK: this ain’t your grandma’s scooter

bmw-motorrad-link.gif

Is it a cool scooter or a small motorcycle? The new BMW Motorrad Concept, LINK, is designed to be a cross between. By making this motorcycle smaller it is designed to navigate congested city streets like a scooter. The electric drive allows for a lower seat, so you don’t have that driving-on-a-bar-stool posture typical of gas-fed scooters. In addition it has:

  • A reverse gear, to aid in parking and other scenarios
  • Under-seat storage for that funky headgear you insisted on getting
  • Cut-away display for the cool built-in, on-board tech

This slideshow requires JavaScript.

Cheers!

hɔuᴉnb

Related Riding Reading:

 

Acrobat Page Numbering

Often times, a PDF’s pagination doesn’t match the pagination as displayed in document. For example, a document containing caption, contents and authorities pages, may have its first narrative page set 7 pages into the file. This makes navigation problematic.

Many courts now require that the PDF page numbering match the original document pagination. Follow these instructions to renumber your PDF.

To Renumber Pages in an Acrobat PDF

To label or suspend numbering for an un-numbered page
(e.g. Caption pages)

  1. Display Page Thumbnails by clicking Thumbnails icon at left.
  2. RT+CLICK on the page thumbnail and select Number pages. The Page Numbering dialog appears.
  3. In the Pages section choose ‘Selected’.
  4. In the Numbering section select ‘Begin new section’.
  5. Click Style drop-down and select None.
  6. Set Prefix to appropriate label (e.g., Caption, CoverPg, etc.) or leave blank.
  7. Click OK.

To renumber pages within a section (e.g., Table of Contents)

  1. Display Page Thumbnails by clicking Thumbnails icon at left.
  2. To select multiple pages, click on the first page of the section, then scroll down and SHIFT+CLICK on the last page.
  3. RT+CLICK on one of the selected thumbnail pages and select Number pages. The Page Numbering dialog appears.
  4. In the Pages section choose ‘Selected’.
  5. In the Numbering section select ‘Begin new section’.
  6. Click Style drop-down and select desired format (e.g., i ii iii).
  7. Set Prefix to blank (i,e. leave this field empty).
  8. Set Start to ‘1’.
  9. Click OK.

Cheers!

hɔuᴉnb

Related posts:

Comments and questions are always welcome!

SOS: Save Our Swiss Alps (with Snowblowers?)

Starting this summer, Johannes Oerlemans of Utrecht University and his colleagues will blow artificial snow onto a small glacier at the foot of Diavolezzafirn, in the south-eastern part of Switzerland. The hope is that a thin white sheet of snow will increase the sunlight reflected, and thus protect the ice underneath from melting, Oerlemans explained at the European Geosciences Union on Thursday (Apr. 27). If this $100,000 pilot project is successful, researchers hope they can raise funding to use the technique to protect the Morteratsch glacier, a huge tourist attraction that’s considered a national treasure—but is shrinking.

via Switzerland will blow artificial snow onto its prized glaciers in an attempt to save them — Quartz