timesheet

  1. L

    Resetting table based on day

    First off, I'm really not experienced at all, just downloaded a free template from a website and just edited it and added a few simple formulas to suit my needs. So, I've got a timesheet that supposedly tracks the start time, end time, project name and all those things, mind you, not a weekly...
  2. E

    Compute Night Differential, and Night Differential OT

    Good Day! How can I compute the number of hours between a specific range, For example, an employee has timed in at 6:00 pm then timed out at 3:00 am the next day. What formula can I use to compute the number of hours that is only within the Night Differential, 10:00 pm to 6:00 am. Note: Night...
  3. L

    Timesheet

    Hello, I am trying to set up a simple time sheet tracker. How can I enter start and end times and then total the hours for each task. I tried in the below example but appreciate any help on this. Thanks Excel WorkbookABCDEFGH3Time Charged To4A/NDateAFR NumberShop OrderOtherStart TimeEnd...
  4. H

    Timesheet: calculating total, regular, ot and pto hours

    Hi, We use Excel for our timesheet. The formulas work well, except for the PTO (Paid Time Off). We can't get it to add to total hours without adding to regular. Here are the forumulas: Total Hours: =ROUND(IF((OR(B16="",C16="")),0,IF((C16<...
  5. Jym396

    Entering numbers is very slow

    Workbook with 3 sheets: Timesheet, Charts, Data. ONLY the Timesheet when I enter a number or time, calculation is slow (~5-6 secs). It does not happen with alpha characters. Dimension for Timesheet is A1:AG566 A few vlookups and many if statements. The thing that puzzles me is this happened...
  6. B

    Calculate Overtime with multiple criteria

    I am trying to make a timesheet that calculates overtime with the following criteria... 1. Overtime is after 8hrs on any given day. 2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime. 3. The after 40hrs/week overtime criteria changes if...
  7. R

    Overtime payroll sheet nightmare!

    Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck! They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day. Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be...
  8. I

    Average calculation of workhours - notice

    Hello, I am trying to make a formula that lets me know when an employee needs to have time off (by law there is a maximum amount of hours they can work in an eight week work period). There are different values for different shifts: Day: 9 hours Evening: 9 hours Night: 7,5 hours Free: 0 hours...
  9. D

    Timesheet

    Hi all, I'm new to the forum so hi and Thankyou for any advice. I am currently working on a timesheet for my partner, the problem I have is the way the sheet works I have a column that accumulates any flexi time over 7 and a half hours but she has started doing half days on Wednesday only so I...
  10. K

    Excel Timesheet minimum hours

    Hi, Sorry bit of a newbie here!! I am making up a new timesheet for one of the departments in my company. Employees in this department get a guranteed payment of 6 hours per day, even if they dont work 6 hours that day so i have used the formula...
  11. V

    User Form - Kept in sharing - asking MsgBox to User - Solution required

    Hi Guys, I have a new query on VBA Form.. I have made one timesheet tracker. on sheet3 button placed, where user need to click to open timesheet tracker userform. (this is one time activity) on sheet1 (besides to sheet3), all the data on userform saved in this sheet. Everything has...
  12. B

    Rota deducting lunch if shift over so many hours

    So I want to get a total amount of hours worked in a day, which takes away lunch of 30 mins if someone works 6 or more hours, what formula do I use? Cheers
  13. V

    find record latest one

    Hi All, I have assign x = TxtProjectID.value (text box) x value are in another workbook called "Timesheet Data" in Col E, with same directory. x = numeric data. I have multiple rows in "Timesheet Data". this x value information may exist multiple of times. What I'm trying to do... The...
  14. S

    Calculating how many hours taken between shifts

    I have been looking all over the web for something similar to what I am looking for but have not found anything so far which suits what I need. I am creating a time sheet where colleagues would input data for each employee, where they worked, start time and end time. As part of the law, we...
  15. P

    Elevate user folder rights from an application

    I have a VBA Excel-based timesheet program that allows employees to submit weekly timesheets. The application itself takes charge of creating each weekly timesheet and saving it to a specific network location (ActiveDirectory). At other times, the application also needs to be able to read...
  16. A

    Time Sheet Calculating Daily Hours Up To 40 Hours

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

    Create a Timesheet in 60 minute format

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

    Creating a Pivot Table from rows of data

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

    copy rows from table with criteria and paste to end of another table

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

    VBA Code to create new template from workbook

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

Some videos you may like

This Week's Hot Topics

Top