My enhancements
As a Part Time Hourly Paid lecturer I have to put in a time sheet, supplied by the university. I get paid at two rates depending on teaching/non-teaching(marking) duties. Dont' get paid for prep, but that's another story. Last month my new boss put in all my hours at the lower rate, so I have now modified the spreadsheet with a column for each rate. As previous contributor, I will send you a copy if you give me an email.
I first modified it in Open Office, then discovered MS Excel didn't like that, so modified an MS version, which worked happily in OO.
The 'A' rate column in the spreadsheet looks like this: =IF(F21 = "A", H21-G21,"")
where column F sets the rate (A or B). The B rate column is similar except for one character.
