Wednesday, May 5, 2010

examples for test

ch 6: date and time
give a bunch of times in and out
get me the sum of the time for the person
multiply by hourly rate
how much does he earn

Bill worked from 4/1/1903 to 5/4/1905. He had off on Sundays and Saturdays, as well as the holidays listed in C5:C30
He got $60 a day. How much did he earn?

Bill came in at 5:30 AM. He worked for 5 hours, 12 minutes and 2 seconds. Generate the time he leaves.

summing over a range using simple functions
and using array formulas

some simple array manipulations

Monday, May 3, 2010

chapters for second midterm

formula: ch 6, 7, 14, 15
grauer: 5, 6, 7