![]() I went to C7, entered an equal sign (remember that we always start with an equal sign if we want the spreadsheet to do calculations), typed the word SUM and an opening parenthesis: The first is to select the cell where we want our total and use the SUM formula, which adds things up. However, we can also just let the spreadsheet do this multiplication for us:Īnd we can do something similar for the days, which is 60*60*24: After hitting the enter key, things looked like this:įor hours, we need to multiply by 3600, which is sixty seconds per minute and sixty minutes per hour. What this says is “Take the value from B4, multiply it by 60, and put that value in C4”. I then typed an asterisk (which is what computers use to multiply it doesn’t matter whether you use Shift+8 or the numeric keypad) followed by the number 60: In C4, entered an equal sign, and then clicked on B4, just like I did with seconds: To calculate the minutes in seconds, we need to do a bit of multiplication. The formula in C5 basically says “Take whatever value is in B5 and put it here”. The red box around B5 shows that I clicked in it. I didn’t need to do anything to the seconds, so I entered an equal sign in C5 and then clicked on cell B5: To get a spreadsheet to calculate things, we enter an equal sign (=) first. To calculate an average, we need to know the total time in seconds and work backward from there. I opened a new spreadsheet and entered the data I had: As it turns out, that was fairly easy to calculate. My music collection is a mixture of pop, rock, jazz, classical, and podcasts, so I started wondering what the average song length was. That translates to 10 days, 22 hours, 15 minutes, and 57 seconds of music. When I was finished, I saw this at the bottom of my iTunes window: I recently upgraded to a new laptop, giving me the opportunity to combine the iTunes libraries from two different computers into one. Most of these tips and techniques should work the same in Microsoft Excel. You should also know that I’m using OpenOffice for these demos and screen caps. I’m assuming that you know how to open a spreadsheet, enter some data, and print it out, and that you know what cells, columns, and rows are. ![]() A lot of this information will be about using formulas, but I will cover other topics as well. My goal is to write a series of short tutorials about some of the nifty things you can do with spreadsheets.
0 Comments
Leave a Reply. |