24 Hour Clock Calculations in Excel

Recently I've been doing some work with Excel to carry out some time calculations based on the results of an automated job. The job is sometimes triggered one night and finishes in the early hours of the next morning. After loading the figures into Excel I discovered that time calculations aren't always as simple as subtraction when times cross midnight. A quick test later and I had a workable solution that I thought might be useful to share.

Click to read more ...

Automating Mail-ins to Evernote from GMail

For some time now I've been hampered by Evernote's e-mail in service. Let me re-phrase that; I've been hampered by the limitations of e-mail in making the best use of Evernote's e-mail in service. Now however, I've found a service that lets me overcome the limitations and open up a wide range of opportunities for today and unimaginable ones for the future.

Click to read more ...

Set an Evernote template file (in ENEX format) to open in Evernote

I recently had an e-mail about one of my posts on Evernote templates on Windows. I've previously recommended using an application launcher to provide a list of evernote imports, but the e-mail was asking if there was an easier way to import templates directly? Well as it happens there is.

Click to read more ...

The Ideal Twitter Client Top 10 Feature List

Each day I access Twitter using a variety of platforms and whilst I find that the clients I use are workable, none of them quite matches up to my ideal. I thought I'd share my top 10 wants from a Twitter client … just in case someone knows of an existing Twitter client that meets these criteria or even wants to create a client that meets all of them.

Click to read more ...

TextExpander: Change Clipboard Case

On Windows I have a useful function in one of my text editors that takes some text and converts the case - to upper case, lower case or sentence case. I realised that on the Mac I could use TextExpander to carry out these functions, so if you're a TextExpander user and want to have this functionality available to you, I've provided some details and a downloadable snippet group for you to use.

Click to read more ...