timesheet

  1. L

    Problem with ISBLANK() functioning

    <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)))))...
  2. M

    Update only the sheet that matchs criteria set

    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...
  3. B

    Formula Help Needed!

    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...
  4. B

    Transfering a variable value from sub to another sub is possible ?

    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...
  5. B

    Sumproduct question - compare two lists

    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...
  6. J

    Timesheet - Hour +/-

    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...
  7. U

    Data consolidation using macro/vba

    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...
  8. R

    Displaying Timesheet Data as Gantt Chart (or equivalent)

    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...
  9. S

    Help needed to create complex timesheet in Excel 2016

    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...
  10. K

    Timesheet OT over 40 hrs/Wk Formula Help Needed - NOVICE

    <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...
  11. P

    Timesheet Calculation

    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...
  12. W

    Weekly Time-sheet Calculator

    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...
  13. J

    Time sheet formula question

    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...
  14. D

    Excel Timesheet Questions

    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...
  15. D

    Creating a split shift timesheet

    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...
  16. R

    Need Help with time sheet

    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...
  17. L

    TimeSheet date forumla questions

    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...
  18. E

    Nanny Share Timesheet

    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...
  19. I

    Timesheet consolidation made easy

    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...
  20. A

    Checkbox to select multiple checkboxs but not all

    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()...

Some videos you may like

This Week's Hot Topics

Top