Apr 6, 2015
As many of you know, I work in a team that delivers IT training courses. Last week I was creating my course schedule for April. I used Excel to draw up the schedule before entering the information into our course booking system. Why Excel? Well it gave me a visual...
Mar 18, 2015
I was recently asked how to calculate the difference between two times where the time period exceeds 24 hours. For example: 08:00 on 1st March to 14:00 on 2nd March (which is 30 hours). In the screenshot below: A2: 1st March 2015 B2: 08:00 C2: 2nd March 2015 D2: 14:00...
Sep 29, 2014
I live and work in the UK but I have many customers based around the East Coast of the USA. In terms of their timezone, it is 5 hours behind the UK. However, because the UK and the USA don’t put their clocks forward and back at the same time, sometimes they are...
Jan 23, 2014
A question that is often asked is “when I add up times and the total comes to more than 24 hours, why does it not show correctly?”. To answer this, I’m using a timesheet as an example: **Download the spreadsheet here** My working day is split into 2...
Jan 20, 2014
Yesterday I was creating a piece of elearning using Adobe Captivate. I had a file that consisted of 33 slides along with a 6 minute MP3 of my narrative. When viewed by end users, the eLearning had to move from one slide to the next with no intervention from the...
