timesheet

  1. G

    Overtime calc on Timesheet

    <!--[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...
  2. B

    Calculation of breaks between workshifts

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

    TIme Sheet Restricting Entry to only allow 5 workdays instead of 7

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

    Calculate total hours in a work week using workdays and punch in and out times

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

    Calculating task duration, hours spent on task, remaining hours

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

    Trying to Create Timesheet w/ Drop Down List for Start/End time & Calculating Hours

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

    Pay per minute time sheet with two rates

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

    Copying time sheet data

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

    Atomatic timesheet creation for individual employee from one master sheet

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

    formulas and different functions

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

    Macro Message Box Help

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

    Excel timesheet - netting sick, vacation, with extra time worked

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

    timesheet event handler

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

    Deriving estimated hours worked from an unsorted list of Subversion (SVN) Check-Ins/Submits

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

    Help creating a timesheet spreadsheet

    <tbody>...
  16. spencer1025

    Hours/Mins Rounding

    [/URL][/IMG] In an attempt to eliminate accidental overtime in my company, I need help making a formula that will accomplish a time calculation and round correctly based on my employer’s minute breakdown of an hour. Reg. time is 7.5 hrs. Our minute breakdown is as follows (A) A 1-3 = 0.00...
  17. N

    Schedule with time sheet and budget all in one, but date and day not working

    hello i am building a monthly schedule with calcs weekly and monthly, i am using the below calculation. AL2 is the date 26/11/12 (always the 26th of the month) cell calcs= a2 =TEXT(E3,"ddd") .... E3=DATE(YEAR(AL2),MONTH(AL2),DAY(AL2)) .... e4=TEXT(E3,"dd") I need the sheet to show; the...
  18. C

    VBA code for Production Tmesheet

    Hi, I work for a printing company and on one of our presses, the operators manually write out time sheets to record their work. This in turn has to be typed up in Excel to do some analysis on performance etc. I am trying to change this so the operators input the information directly into...
  19. B

    Is this even possible in Excel? Count a series of cells that contain values IF:

    Working on a small calculator which will hopefully allow me to save a ton of time with my daily tasks. The spreadsheet in question is supposed to help me determine if any of my truck drivers are outside of the legal limit for on duty hours. Basically, my spreadsheet is divided into rows of 96...
  20. R

    Timesheet

    Good evenning! I have a sheet for diary filling and another one, in the same workbook, that resume the day by acummulating the hours spend in each project and calculating the cost for each projects. What i need to find, is a way to export daily data to another sheet that acumulates the...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top