Category Archives: Microsoft Excel 2003

Microsoft Excel – difference between times to the nearest hour

If you have two dates and times in Excel, you may want to find the difference between then to the nearest hour. There is more than one approach to this problem. Say I have two date times as shown below: … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged | Leave a comment

Microsoft Excel – month name from a date

I was at a local client earlier this week – face-to-face training at last after so much time. They had entered dates in two columns – one for months and the other for years. Since they wanted to be able … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | Leave a comment

Microsoft Excel – including a date in a text string

There are occasions when you may want to include a date in a text string in Excel. The method shown here is slightly convoluted but it does work! If my original date is in cell A4 (I used the =TODAY() … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – Creating timetable by adding minutes to time

I was asked by someone who was creating a timetable for music exams how to get Excel to calculate the next exam time, knowing how long the exam would take – for Music Grade exams depending on the Grade and … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – Calculating the difference between times

If you are collecting data in terms of dates and hours and minutes, you may well want to find a time difference between two columns, e.g. time needed to service calls, time taken for order to be dispatched, etc. First … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | 1 Comment

Microsoft Excel – Adding data across worksheets where labels are not all in the same place

If you have data in several worksheets which you want to add together and the labels are not all in the same place, you can do so using the Consolidate feature on the Data tab . Suppose I have two … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – due date end month following invoice date

I was doing some online virtual Excel training last week and the client asked how to work out the due date on invoices if it is the end of the following month after the invoice date. There is an Excel … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – working out school year from date of birth

School years run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | 16 Comments

Microsoft Excel – quickly unhide all columns or rows

If you have hidden multiple rows or columns in Excel, it can take a while to work out what you have hidden to unhide again. It is also hard to work out how to unhide column A or row 1! … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Leave a comment

Microsoft Excel – date format of Monday 1 Jan 2018

I was asked whether I could create a date format of Monday 1 Jan 2018 and copy it down to Tuesday 2 Jan 2018 etc. This requires a custom format. However, I also found it required me changing my computer … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | Leave a comment