time card

  1. K

    If/Then Problem for Time cards

    Hello Excel Geniuses! I am in need of some help to get the brain juices flowing on this Monday morning. Here's the scoop: I have created a time card calculator to calculate total time worked and distribute it to regular and overtime hours. Currently I have it set to calculate if over 8 hours...
  2. E

    Units to Minutes time card conversion

    Can someone help me with a formula to convert units to minutes for my time card? 10 Units= 60 minutes. lets say if there are 12 units how do I convert this to the exact minutes?
  3. K

    Shift totals according to a standard Time Clock

    My goal is to differentiate a standard timecard's hours into three shift totals. My Shifts are 7:00 am to 3:00 pm, 3:00 pm to 11:00 pm and 11:00 pm to 7:00 am. (7-3, 3-11, 11-7) I want to be able to show my "Check in/Check out, Check in/Check out" in four columns to the left and then on the...
  4. J

    Force users to Input hours on timecard

    Good Morning. I have a master workbook that is feed from employee time cards. what is to make sure that there are certain cells filled out when a code is entered into the following merged cells If Range "Type" is not blank, corrisponding Range "Hours" the same row needs to have a number. i...
  5. C

    Writing formulas for time sheets

    I am currently trying to adjust a formula for our time sheets. The current formula takes into account when a person works over 8 hours to consider that "banked" time (comp time). I now have an employee that will be working 8 hours one day a week and 6 hours the other 4 days. The current formula...
  6. H

    Record time

    Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 104px"><col style="WIDTH: 104px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody> C D E F G 1 1 or 0 Time T1 when 1 appeared last in C Time T2 when 1 disappeared...
  7. K

    VBA - "Find" with "where"

    Hello there guys! First, thank you for your community and everyone inside of it! And sorry... probably my english is not perfect... So... I need to create a way to do a "find" with a "where" on it... let's say... "Find Date where ID = Me" The thing is: I need to find a registry in a table and...
  8. R

    HELP I need code that will locate duplicate text

    Greetings friends, I have limited excel knowledge and experience, yet despite that, through the painstaking process of searching online forums such as this one, i have managed to create a "Employee Punch in/out" userform. So far i am happy with it. Here is how it works: A employee types in his...
  9. J

    Timesheet w/ if statement to add overtime

    I'm trying to figure out the formula for a timesheet. I have one rate for "drive time", another rate for "service time". But if the start time is after 17:00, then it's an overtime rate. Then Saturday/Sunday rate creates another variable. I've looked through the posts and can't find a...
  10. M

    Shift time in 100 minutes (calculate)

    Need to calculate the time worked sometimes between 2 days, and it is military time in 100 minutes. Examples: In 5/19/09 06:00 (which is 6:00 am) Out 5/19/09 16:50 (which is 4:30 pm) In 5/19/09 18:10 (which is 6:07 pm) Out 5/20/09 06:25 (which is 6:15 am) Then I want to take out .50 (or...

Some videos you may like

This Week's Hot Topics