timecard

  1. J

    Looking for a formula for time

    I want to make a timecard calculator that tells you what time you need to clock out so an employee does not work over 40 hours in a week. Also the timecard displays time in a 100 minute clock. (Example) Employee worked 32.68 hours by Thursday, start time on Friday is 8:00am, lunch out is...
  2. B

    Timecard Help

    I am working on a timecard worksheet that calculates the time worked between the start time and end time. I can get it to calculate and round to the nearest quarter hour, but I also want it to max out the regular hours at 12.25 hours than its OT. This is what I have so far that I'm using and...
  3. T

    Identifying Timecard Overlaps

    Hello, thank you in advance for any replies. I am trying to piggyback off an older thread here to develop a spreadsheet formula tool to identify timecard overlaps. https://www.mrexcel.com/forum/excel-questions/709968-calculate-amount-overlapping-time.html#post4932454 I can provide a google...
  4. W

    Automated Timecard Calculations - Not adjusting RT and OT

    The formulas I have in the sheet were working great, until I worked a day with less than 8 hours. The timecard is not correctly totaling the RT and the OT. I tried changing the formula to take from the total in Column F, which it didnt like because it created a circular logic. Any suggestions...
  5. W

    Automated Timecard Calculations

    I have a timecard I have created that I am having some trouble with 1 particular formula. Our state law on OT is over 40, not over 8 and our employer allows us to work more one day to make up hours another day. So I can't use some of the formulas I have seen out there. What I need it to do is...
  6. S

    Timecard tracking and pivot tables

    What I need is relatively simple, or so I thought. I have employee names in one column and across the top are the dates of the week and hours are put under each employee for each day. A calculation is at the end calculating the total hours and then the summary has their rate multiplied for the...
  7. S

    Enter two values solve for third

    Good Day, I'm trying to design a timecard worksheet which will allow me to enter in two of the following pieces of information and then automatically solve for the remaining value. Shift start Time worked Shift end Anyway I could do this without a macro? Thanks!
  8. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top