Excel formula to convert minutes into Hours and Minutes

On occasion I end up with an Excel spreadsheet that has a list of items, each of which has a duration. It’s easy to sum up the minutes and get a total number of minutes (see B7 in the picture below).

But it would be nice to see that in “x hours y minutes.” don’t you think? Yup, so do I. And that’s what I’ve done in the C9 cell in the picture below.

Screen snippet showing a column of minutes summed up, and then convert that into human readable hours and minutes
Human Readable Hours and Minutes

So without further ado, here is the Excel formula to do this

=ROUNDDOWN(B7/60,0)&" hours "&MOD(B7,60)&" minutes."

Let me know if you find this helpful.

Editing Microsoft Office Documents on the iPad

I got asked on the weekend about what do I use on the iPad to edit Microsoft documents.

I’ve been using an iPad (the ‘new iPad’ or the ‘iPad 3’ depending on who you talk to) and have been needing to both create and edit Microsoft Office Word and Excel documents.

I’ve tried using Google Apps but have found that it just wasn’t that easy, and I had to be online, which wasn’t a problem most of the time, but occasionally was quite frustrating if the connection was either slow or non-existent.

So I hunted around for a native app, and ended up with Quick Office HD, which is perhaps the most expensive app I’ve bought. However, it has proven to be very well spent money.

I’ve been able to open existing files, create new ones, save them to a Dropbox folder and either have them available on my workstation or laptop, or email a colleague a link to the file. This has proved to be a great combination (Quick Office HD and Dropbox).

As it so happens, Quick Office has been acquired by Google, so I’m hopeful that sometime in the near future a better option will exist for Google Doc’s.

Quickly Create Bulleted Lists On iPads

I’m a newcomer to the iPad, but I’ve found that creating a bulleted list in an email can be rather time consuming as to get an ‘asterik’ (star, SHIFT-8, one of these *) takes a few taps on the keyboard.

I’ve found a quicker way to make them happen, here it is:

  • Go to Settings
  • General
  • Keyboard
  • Add New Shortcut
  • The ‘Phrase’ is ‘* ‘ (that’s a star followed by a space, without the quote marks)
  • The ‘Shortcut’ is ‘,,’ (that’s two comma’s)

Now when I type two comma’s followed by a space, it’ll replace that with a star followed by a space. Great easy bulleted lists in emails.

20121009-144655.jpg