timesheet

  1. C

    Complex overtime worksheet

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I can calculate my overtime into 2 diferrent rates including weekends, but I need to enter manually any 2UP (Row/Cell AH) or Wait time hours (Row/Cell AM)which both need to be deducted from the daily hours...
  2. S

    Dropdown tallys by category

    Hello, I have a spreadsheet that tracks type of time worked in .5 hour increments with a dropdown menu that has items from multiple categories. The people using the timesheet would select what type of work they did that half hour and it totals a full day of work. BUT I need to try to create...
  3. Z

    Timesheet formula for calculating ordinary hours and overtime hours.

    Hi I am building a timesheet and I have become a bit stuck. I have already got the timesheet to automatically calculate the number of hours once the start time and end time are entered(these cells are all in hh:mm format). The column which calculates the total time is AA4. Then I have the...
  4. D

    calculating time with 1/4, 1/2/ and 3/4 of an hour increments

    Hello, Please help!!! We have a client who will pay using the 1/4, 1/2/ and 3/4 of an hour increments as follows: From the hour mark to 6 minutes = 0 time paid Over 7 minutes to 15 minutes = 1/4 hour 15 16 minutes to 30 minutes = 1/2 hour 30 30 minutes to 45 minutes = 3/4 hour 45 46 minutes...
  5. J

    VLOOKUP and wages in timesheets/rosters

    Dear all, Having had alot of success here I am turning to you all to help me. I am trying to create a time sheet that will return two different results depending on the salary structure. I have successfully create the formula for a employee on a casual rate to look up the level they are on...
  6. C

    Timesheet formula needed

    I created a timesheet from a few different templates and them modified them. Basically I need a page that allwos me to specify an end and start date, then it exstracts the hours spent on each project within the specified date range. For example, if I choose 4 projects from a drop down list, then...
  7. C

    Organize data into sheets by Date

    Greetings! I've got some timesheet data: 9/7/2010 661 minutes 11.02 hours 11.02 hours 9/7/2010 661 minutes 11.02 hours 11.02 hours 9/7/2010 661 minutes 11.02 hours 11.02 hours 9/8/2010 475 minutes 7.92 hours 7.92 hours 9/9/2010 445 minutes...
  8. J

    Sum time in a period

    I'm working on what is essentially a timesheet to help a friend calculate expected pay, but I've run into a roadblock in one area and would appreciate some help. I have a date/time when she punches in and another when she punches out. Calculating total time spent on the job is easy, but I also...
  9. P

    Accumulated Time Formula

    Hi, any help would be much appreciated. I've looked for a solution but can't find something that meets the specific needs. I need a formula that counts up the accumulated hours per day in a time sheet, then calculates the total lunch time taken during a week and subtracts it to give me the net...
  10. T

    Formula for time through different rates help

    hi all I can't work out how to calculate the number of hours split over different time rates. assuming col a = 09/03/10 col b = 18:00 col c = 03:00 I need to break the hours down as follows: col d = hours at basic (which is mon 09:00 - 20:00). col e = hours at unsociable (which is mon 20:00...
  11. K

    Timesheets and total time against projects

    OK we use a 52 sheet excel work book to track our hours against project numbers 08XX for 2008, 09XX for 2009, 10XX for 2010 etc. Each sheet is named by the week for example May-15. The challenge is that everyone works on different projects and doesn't use a static list of project numbers...
  12. J

    Need help creating timesheet

    I want to create a time sheet with the following columns... Time In : Lunch Out, Lunch In : Time Out So basically, people put time in as 8:05 am and time out as 4:45 pm. I need the formula to calculate that this equals 8 hours and 40 minutes plus subtract out if the person takes a lunch. I...
  13. A

    Master timesheet w/multiple employees

    Greetings, I am looking for a solution that will enable me to capture time, monthly, from several employees and merge/consolidate data into one master file based on assigned project. Employees are assigned to at least one project and some are entitled to overtime if weekly hours exceed 40...
  14. S

    Whats wrong with my formula?

    I cant for the life of my figure out why my formula won't recognize my 40:00 hours. I am trying to have it add up my timecard and put the regular hours in one cell and the overtime hours in another cell. I almost have it except for in the normal hour cell it wont recognize the 40:00 hours and it...
  15. S

    Can I multiply a number and have it display in minutes?

    I am trying to multiply a normal number (1,2,3 etc...) by 20 minutes and have it display in in hours or minutes, whatever it may be. Example: If you do not take a break at my work, you get paid an extra 20 minutes. So I want to be abel to Have a place on the timecard that goes something like...
  16. N

    forumla that needs more.......

    I am looking for some help on a formula.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> purpose time keeping;<o:p></o:p> User enters hours worked, (column B) program tracks hours worked in the last day, 30 days, 42 days and 90 days.<o:p></o:p>...

Some videos you may like

This Week's Hot Topics

Top