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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top