timesheet

Hello there you intelligent bunch of cell crunching people.(please note the flattery ;) ) So I have a new clocking machine for my employees and its a VERY basic system. So it exports a TAB delimited file which i manged to sort easily enough. What i then did was put it into a Pivot table in a...

Thank you in advance to anyone willing to help a beginner out. I have read multiple posts but I'm still stumped. Here it goes: I would like to have three active columns: "Column B" a date in 1st, 2nd, 3rd, etc. format. (Cells B10 through B25) "Column C" a day of the week in Mon., Tues., Wed...

Hi there! I am a nanny for 3 different families at once. Each family pays me a different rate depending on the combination of children. For example, when Family A's child is the only child in my care, they pay me $10/hour. When I have Family A and B's children, A pays me $5/hour and B pays me...

Hello Excel Gurus, I’m building up a system for about 20 employees to report their time at project level and consolidate all entries. It’s meant for capitalizing software costs developed inside the company. I am thinking to build a timesheet template with drop-down menus where employees can...

Hi, I could really do with some help. I'm creating a timesheet for work where a user clicks on a check box which only selects the checkboxs for weekdays in a month. At the moment it auto selects everyday. This is the code I'm using to select all the checkboxs at once: "Sub CheckBox1_Click()...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi Guys! Good day! I need to adappt the formulas from Barry Houdini to work with two shifts, with a rest interval, being the rest during the day or during the night. Overtime is...

Guys please help as I ran out of ideas: I need to calculate workers' rest time between two shifts, example Day 1 Time in: 8:00 Day 1 Time out: 23:00 Day 2 Time in: 8:00 Day 2 Time out: 17:00 Rest between shifts: 9hrs [so formula would be Day 1 Time out - Day 2 Time in, but it never returns...

Hello, I am setting up a time sheet for my employers to use. There are 7 days in a week but I want to set it up in such a way that the user can only input work hours for 5 days a week and prohibit them from inputting anything on the other 2 days. For example, if Employee A worked Mon-Fri, then...

I have a list days and clock in and out times. I would like to calculate the total number of hours worked in a work week. The work week begins midnight Sunday and ends at 11:59:59 Saturday. The punch in and out times are in military format. Employees don't work every day of the week. My problems...

Hey, Need your help asap. It would mean a lot to me. I have the following information: - employees that work 20 hours/week; - 100 hours/project; - employees are assigned activities that have a start date and a due date; - start date and completed dates are formatted as date, type...

I'm trying to create a time-sheet in excel, where my employees will only have to select an in/out time and the sheet will calculate their hours as a decimal. I know how to create a drop down list for each field (Start / End). I structured the list to allow 6 minute increments to be selected...

Hi all! I am new to this forum, although I have used it to solve a lot of my problems previously. Thank you all very much for your help in posting different solutions! I am not sure how to approach a solution for this: I am trying to create a time sheet that will calculate rate per minute...

Hi, I have a spreadsheet (in excel 2003) containing a years worth of timesheet data, arranged into columns which include job number, stage and the days of the week for Monday-Friday. Hours per day are put against a project and/or stage. The spreadsheet is arranged into worksheets with two weeks...

Dear Friends, I just joined this forum and found it so useful with great talents from member about MS Excel. Hoping somebody can help me out with this problem that I struggled to figure out how to come up with solution for preparing monthly time sheet for each employee from master sheet...

Hey there i am currently working on a spreadsheet involving a whole lot of formulas and im trying to figure out the sum of a few things. the first is the total hours spent on each task in a project (ie: painting, tear out, doors, flooring) the second is each employees total time on one whole...

Im trying to create a time sheet for work. I have created it so that one column auto populates with each persons expected hours, and a hidden column next to it shows the difference in the hours that they were supposed to work and what they actually worked. I would like a pop up message to warn...

Hi, I like many other do not pay OT until a person actually works 40 hours. So if a person works 10 hours on Monday (2 hours of OT) but takes 2 hours of sick time on Tuesday. I want my spreadsheet to Net the sick time on Tuesday against the two hours extra time worked on Monday. I think...

I want to install a Workbook_SheetSelectionChange Event to simplify my timesheet. When I click on a new time cell (triggering the event handler), I can sign in or out. At that point I want to be able to enter a 1-4 digits (no colon) so the program outputs the right time with a colon and...

Hey excel gurus, Slightly complex one here...and I'm no excel expert. I have a spreadsheet full of SVN check-in times for a group of programmers, as seen below. Note that it is sorted by revision number, not by name, and that it's in reverse chronological order. I want to assign an "time...

<tbody>...