Free computer Tutorials
Microsoft Excel 2007 to 2013
A Timetable Project
In this Excel timetable project, we'll set ourselves some chores to do around the house. We'll plan an exact time to start a task, and how long it will take to finish. We'll be adding one time to another.
So create the same spreadsheet as the one in the image below (you don't
need to use the same colours):
What we're going to do is enter a Start Time for our chores. This will be 9 in the morning. Then we'll estimate how long it takes to wash the pots, which we'll place in the Time Job Takes column. We'll add the "Time Job Takes" to the "Start Time" to get a new start time for the Hoover chore. But you'll see how it works as we go along.
The first thing to do is to format the Start Time column:
Click on the arrow (circled above) to bring up the Format Cells dialogue box, and then click the Time category:
Excel will enter the hours, then minutes and the seconds. We don't need the seconds. Unfortunately, this version of Excel doesn't give you a time format without seconds. To remedy this, click on Custom under the Category list on the left. Then, under Type, select "h:mm AM/PM", as in the image below:
Click OK when you're done.
We'll now enter our first time.
There is a simpler way to format a cell as Time, though. Try this:
Because you included the colon (:), Excel knows that you want to format the cell as a time. The 0:15 then means 15 minutes (We'll assume that we're very fast at washing pots - it's all that practice!).
But your spreadsheet will now look like this:
If we started at 9.00, and the job took 15 minutes, the next start time will be 9.15. We can enter a formula for this:
= B3 + C3
The start time for our next chore, then is 9.15 AM. We can use AutoFill for the rest of the B column:
Because we haven't yet entered any other figures for the "Time job Takes" column, a time of 9.15 will appear in all the cells.
Complete the rest of the spreadsheet for yourself. Enter these times in the C column:
Rest: 30 minutes
If you complete it all correctly, you should have a spreadsheet like
ours in the image below:
In the image above, you'll notice that there is a time in cell B9 of 12:45 PM. You should easily be able to get the same figure in your spreadsheet!
Working with date and times can be quite tricky. But it's well worth
getting the hang of. We'll move on, though, and have a go at financial
functions in Excel.