Discussion on:
View:
Show:
Great idea, in keeping track of hours and work done!
If the worksheet is intended to be used for multiple clients and/or projects, sorting is required and the worksheet must be unprotected to do so. I prefer dedicating a worksheet to each client.
I recommend adding this comment somewhere on the worksheet:
To quickly enter Date & Time values, use these shortcuts:
For current Date: type Ctrl + ;
For current Time: type Ctrl + Shift + ;
I recommend formatting Hours as a Number with 2 decimal places, and Amount as Accounting.
I recommend adding this comment somewhere on the worksheet:
To quickly enter Date & Time values, use these shortcuts:
For current Date: type Ctrl + ;
For current Time: type Ctrl + Shift + ;
I recommend formatting Hours as a Number with 2 decimal places, and Amount as Accounting.
Thanks Susan for the straight forward and simple to use report. Of course, entering dates and times with Excel requires more keystrokes that I care to enter, so I made a few changes for you to consider.
Our (in house) CRM software suite includes this familiar function.
I've taken your 'xls' file and expanded on it 'a mite'
Tell me where to send it if you're interested.
Merry Christmas and Happy New Year to TechRepublic/CNET
DonWagner@fccss.net
Z01.00~20101207TU@070103840~ IDtLine Our Global LOG Format
Our (in house) CRM software suite includes this familiar function.
I've taken your 'xls' file and expanded on it 'a mite'
Tell me where to send it if you're interested.Merry Christmas and Happy New Year to TechRepublic/CNET
DonWagner@fccss.net
Z01.00~20101207TU@070103840~ IDtLine Our Global LOG Format
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.
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.
ManicTime.com the free version is enough for me.
As a contractor, I needed something I didn't need to maintain.
It's a nobrainer.
It's easy.
It's flexible.
It exports everything I need.
WTG TechRepublic!
As a contractor, I needed something I didn't need to maintain.
It's a nobrainer.
It's easy.
It's flexible.
It exports everything I need.
WTG TechRepublic!
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
