If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I fill a time sheet from a calendar
Every 15 days I have to make a timesheet for my hours I worked. So each time
I have to change the weekends, because I don't work them. I also have to insert the time I usually work. Like so. 9:00 12:00 12:30 5:30 Is there a way I can have the timesheet look at a calendar and fill in the weekends for me, and insert the above time in the other days????? |
#2
|
|||
|
|||
How can I fill a time sheet from a calendar
Hi Peter, Check out my attachment. It looks at the last day of the payperiod (15th and End of Month) and shades the weekends at 50% so that if any weekends were worked, one can make out the figures. It also changes the fonts for each job or contract line item number, so that it's easier to see which ones had any hours charged to it for that payperiod. All the magic happens w/o VBA. And it's worked well for me since Office 97, a few years ago. I've highlighted all of the cells that you need to examine for *Conditional Formatting *and/or *Formulas*. While i only have to mark time by the number of hours worked, in your specific case, you'll have to chage your layout to match the way you mark time by the clock. In any case my sample should get you going. HTH +-------------------------------------------------------------------+ |Filename: Sample Timesheet.zip | |Download: http://www.excelforum.com/attachment.php?postid=4069 | +-------------------------------------------------------------------+ -- AH·C ------------------------------------------------------------------------ AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108 View this thread: http://www.excelforum.com/showthread...hreadid=488086 |
#3
|
|||
|
|||
How can I fill a time sheet from a calendar
I went on the page, but can't find it, can you email it to me
please.......Peter "AH·C" wrote in message ... Hi Peter, Check out my attachment. It looks at the last day of the payperiod (15th and End of Month) and shades the weekends at 50% so that if any weekends were worked, one can make out the figures. It also changes the fonts for each job or contract line item number, so that it's easier to see which ones had any hours charged to it for that payperiod. All the magic happens w/o VBA. And it's worked well for me since Office 97, a few years ago. I've highlighted all of the cells that you need to examine for *Conditional Formatting *and/or *Formulas*. While i only have to mark time by the number of hours worked, in your specific case, you'll have to chage your layout to match the way you mark time by the clock. In any case my sample should get you going. HTH +-------------------------------------------------------------------+ |Filename: Sample Timesheet.zip | |Download: http://www.excelforum.com/attachment.php?postid=4069 | +-------------------------------------------------------------------+ -- AH·C ------------------------------------------------------------------------ AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108 View this thread: http://www.excelforum.com/showthread...hreadid=488086 |
#4
|
|||
|
|||
How can I fill a time sheet from a calendar
What couldn't you find? Conditioning formatting? Select any one of the YELLOW highlighted cells and click on Format Conditional Format to see the formulas I used. I'd send an email, but you need to be registered. -- AH·C ------------------------------------------------------------------------ AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108 View this thread: http://www.excelforum.com/showthread...hreadid=488086 |
#5
|
|||
|
|||
How can I fill a time sheet from a calendar
You've got to be kidding you are posting to a newsgroup, nobody has to
register with a excelforum and nobody should put up with advertising when posting to a newsgroup. His email address takes a little bit of deciphering. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "AH·C" wrote in message I'd send an email, but you need to be registered. |
#6
|
|||
|
|||
How can I fill a time sheet from a calendar
David, who & what are you talking about? Advertising?!? Me?!? IRC, from my activity in Excel-L years ago, one could email one another via the list. Otherwise, I'm not putting my addy out in the open. -- AH·C ------------------------------------------------------------------------ AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108 View this thread: http://www.excelforum.com/showthread...hreadid=488086 |
#7
|
|||
|
|||
How can I fill a time sheet from a calendar
Did you confuse me with someone else? You were so very kind and helped me
with a post I had on exel........Peter "AH·C" wrote in message ... David, who & what are you talking about? Advertising?!? Me?!? IRC, from my activity in Excel-L years ago, one could email one another via the list. Otherwise, I'm not putting my addy out in the open. -- AH·C ------------------------------------------------------------------------ AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108 View this thread: http://www.excelforum.com/showthread...hreadid=488086 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
time sheet to calculate 2 different columns | John Sullivan | Worksheet Functions | 1 | October 21st, 2005 06:48 AM |
Calendar should allow scheduling appointments in any time zone | Art H | Calendar | 1 | August 19th, 2005 11:25 PM |
Calendar control and time control | Dr Alok Modi MD | Database Design | 0 | June 13th, 2005 11:56 AM |
Time Sheet Calculation Help Needed! | sax30 | Worksheet Functions | 2 | April 26th, 2005 08:08 PM |
Access Calendar | lost | General Discussion | 2 | July 7th, 2004 04:58 AM |