timesheet

Hi I have been trying to figure this out for weeks. I need my total daily hours in my regular hours column to only calculate up to 40 hours then anything over 40 hours to total in in the overtime cell. Right now it just totals the total work hours worked for a day in the regular hours, but I...

I need to create an excel timesheet to keep track of my temp employee. Details... Monday - Friday Work Week 1 hour unpaid lunch Need to keep track of total hours for week (in 60 minute formula not 100) Example: need it to say 7:50 instead of 7.83 Also, Since she is temp, her contract is for...

I struggled to word the title of this thread properly... so here goes the explanation. I have a set of system-exported data that shows me how much margin/profit we make on a particular timesheet that comes in from some of our contractors. The deals that are done are split between our sales...

Hello Everyone, i am trying to copy raws/data from one table with 2 cumulative criteria: Hours & Jobcode should be completed. I then need to paste it at the end of another table. I have the following issues with my current code: - No critera for copying - Copy all raws until last row with data...

Hi there, I am new to VBA and after endless hours of searching for my required code I have landed here in the hope someone can help me please.. I have created a time sheet within excel and I would like to add a command button to the workbook so that any user can simply click on the button and...

<tbody> in 8:00 8:00 out 12:30 12:15 in 13:30 13:15 out 17:30 total 8:30 6:37 15:37 15:37 </tbody> function for the first total (in cell B10)=IF(ISBLANK(B6:B9),"0",IF(ISBLANK(B7:B9),NOW()-B6,IF(ISBLANK(B8:B9),B7-B6,IF(ISBLANK(B9),(NOW()-B8)+(B7-B6),(B9-B8)+(B7-B6)))))...

hello alll: I have two workbooks 1 is called moneysheet 1 is called timesheets the money sheet is used for workers to sign in in the timesheet workbook i have many many sheets named Dec1,Dec2, Dec3,etc,etc all these sheets have the same fomulas because they are copied directly from the sheet...

Hi, I'm in need of a bit of help developing a formula... I currently use the following formula to calculate hours worked on a timesheet...

Hi guys, Im having trouble with a userform which contain textbox and combobox and I asked my question in a couple of part. Firstly, ım trying to do when I activate the userform , it is supposed to ask me TimeSheet Num. That is so easy but the thing that ı get stuck on getting the TimeSheet...

Folks, Hopefully a simple query. In simple terms, I have a large list (circa 40k) of timesheet entries (in a worksheet named 'Timesheet Entries') with three columns: a) Column A: Staff Name b) Column B: Time (hours) c) Column C: Hourly Rate In a separate worksheet ('Report' / Column A), I have...

Hi i have this table for a timesheet with the following formula: <tbody> H I J K Day In Out Formula OT 25% OT 25% Formula OT 50% OT 50% 1 8 17 =SI(I3>=19.1,"3",(I3-H3-9)) 0 =(I3-H3-9-J3) 0 2 8 19 =SI(I3>=19.1,"3",(I3-H3-9)) 2 =(I3-H3-9-J3) 0 3 8 21 =SI(I3>=19.1,"3",(I3-H3-9)) 2...

Hi guys, hope you're all having a great Tuesday! I've got a question about VBA, I am very new to this and I have been asked to create a sheet to record time for certain tasks. This is what I have made so far so you can get a better idea of what I have constructed: Essentially, user clicks on...

Hi All... First post, be patient... And kind... I have a spreadsheet with what is essentially timesheet data... Start, End Times... Duration (a calculation)... A "Task Description"... A Date (And other pertinent stuff in the row) I would like to display this data as essentially a "Gantt...

Hi All I'm new to the forum an Excel. I employ a number of carers that I’ve got to create a timesheet for. Yes I’m disabled and have a number of carers that work different shifts at different rates for me. I used to do it by hand but find it difficult to write now. So I'm trying to computerise...

<colgroup><col style="mso-width-source:userset;mso-width-alt:2645;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:1735; width:37pt" width="49" span="9"> </colgroup><tbody> Day Date In Out In Out In Out REG OT Sunday 21-Aug...

I have inserted a formula and I'm not getting the right answer. Cell D, F and H have the time I clock-in and E, G, and I when I clock-out. This is the formula I used =((E19-D19)+(G19-F19)+(I19-H19)) so it would be ((8:45-8:00)+(13:00-12:00) +(19:00-17:00)) to equal the hours worked. It should...

Hi Guys a new member and post so please go easy if this has been asked before. I organise some timesheets for a company i work for and need an easier way to input the hours etc i currently use a printed version of this picture below. My Questions are : i would like to make an excel file...

I created a weekly time sheet to calculate my total hours worked, based off of an example I found online. It has been working very well for me for over a year. However, it just occurred to me recently that while the sheet is calculating "overtime hours", it does not calculate remaining hours to...

Hi everyone, I'm currently new to this site and i'm in need of some excel help. Basically, I'm working for a construction company and we need to know who is on site at all times. So timing is only important, however, knowing how many people are on the site is the most important thing in...

Hi guys I have created a timesheet for my crew that will work out how many hours worked each day and then work out their pay. At the moment i've done it for one shift per day, however, i need it to be for two just incase. Can anyone advise me the formula to use. I currently have...