clock

  1. D

    Time format question

    The time is returned in the military and it should be in the 12 am-pm clock. Cell G 12 9/27/19 (date format) Cell H 12 5:08 PM (Time format) Cell I 12 Formula TEXT(G12,"mm/dd/yyyy")&" "&TEXT(H12,"hh:mm") Cell I 12 Formula Results 09/27/2019 17:08 I would...
  2. G

    Calculating a Clock-Out Time for the Week

    Hi guys, Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX. Column1 is the total so far in the week. Clock In Time is Todays clock in time. If the Recommended Clock out time is 12 hours or more away, have it display a text. <tbody> <tbody>...
  3. L

    Formula to Calculate Clock Out Time

    Hi, Can someone please come up with a formula? If I clock in at 8 am (cell L5) and need to work 9 hours (cell O2) what time do I clock out? There is a lunch break: L2 (12 pm) L3 (1 pm) Also this may be a job that carries over from the previous day as in the 18.0 hour JOB TIME can the...
  4. M

    Flickering spreadsheet due to VBA codes

    I have the following Module that inserts a ticking clock, with the current time , on to a worksheet that is used to send automated emails once past a certain time. I also have a VBA Code that takes photos from my desktop and inserts them into the same spreadsheet based on the name of the saved...
  5. B

    Running clock

    Hi I am looking for a macro/VBA code which will put a running clock into a cell showing the current time but I want it to run when the workbook is opened, I have looked and nothing I have found so far works for me I am fairly new to excel
  6. 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...
  7. F

    Macro to Look for Differences in Time

    Hello, I'm building a macro that identifies time errors to be fixed off a report that includes employee clock in/clock out times. The only values that matter are the actual clock out times vs. system clock out times. Specifically, if an employee physically clocked out at one time, but the...
  8. J

    Calculating Between Two Times in HH:MM "AM / PM" Format

    I have a massive list of employees who worked more than ten hours in a single shift. A2 = John Smith B2 = 7/15/18 C2 = 11:57 AM D2 = 4:03 AM My problem is that we use ADP and in our system, you can clock in 7 minutes before or after the start of your shift and still get credit for starting at...
  9. S

    Need Help with excel Formula

    I'm building a time card calculator to compute number of hours worked per day Clock In/Clock Out...need HELP rewriting the following formula... =MROUND(IF((OR(B13="",D13="")),0,IF((D13<B13),((D13-B13)*24)+24,(D13-B13)*24)-C13/60),1/60) I need this formula to calculate exact time/hours and not...
  10. O

    clock macro

    Hi all... looking at a few threads i'm not finding what i need. wondering if i could get help to create a clock macro. I would need it to run when clicking start timer button in a user form, update Cell B22 with the current time on sheet named SMC Planner every 5 minutes, and when i close the...
  11. L

    cool applications using vba

    Hi Once, I saw a site which has .xlsx files which demonstrate cool applications like Analog clock, games, digital clock, thermostat etc. I tried to google but no success. Have you seen such website or do you know one. Thank you so much.
  12. J

    Volatile Time calculations

    Hi, I'm wanting to calculate a time from when a user clocks in to the current time though unsure the best way to go about it. Currently I have a cell with now() Then subtract the clock in time from current time. Though this makes all the cells volatile right? Is there a better way to do this...
  13. J

    Formula Help

    I have a spreadsheet that I’m using to calculate hours worked. column headings are ”Clock In”, “Meal Hour 1”, “Meal Hour 2”, “Meal Hour 3”, ”Meal Hour 4“ & “Clock Out”. After the clock out time there are Stright Time Hours Worked, Time & 1/2 Hours Worked, and Doubletime Hours worked. I want to...
  14. J

    Need help with formula.

    For the table below, I need formula that will calculate the number of straight Time Hours btw the clock in and clock out times, but I also need it to add an hour for everything break hour that is worked through. I tried a combination of conjunctive IF's with AND/OR with no success. Any help is...
  15. H

    Time Clock

    .
  16. G

    Macro to copy several items based on several conditions and paste on specific cells of another workbook

    Hi there, I'm need of some help please, as I'm currently having to track and compile all the data mentioned below manually. Here is the situation: I have a workbook with several sheets. Each sheet contains a weeks worth of punch times for several employees. The data on each sheet is always...
  17. S

    Time Stamp Help

    Hello everyone! I'm currently working on a Macro-enabled Timesheet for my job where the employees can click a button to record the time they come in to work and leave. I have 4 fields that require a timestamp per day (Clock in for the day, clock out for lunch, clock in from lunch, and clock...
  18. F

    Help needed!

    Hi All, I have a report which shows clock in and out times for staff members. This literally shows every time they clock in/out during the day, but what I want to do is easily find just the first and last clock in/out. The below link shows an example of the data...
  19. K

    Spreadsheet for calculating pay, multiple differentials

    Hello, I am trying to figure out how to make a spreadsheet that can calculate my gross pay. I get a base pay along with zero or one of three shift differentials, depending on when I work. An example is below. What I have right now is a spreadsheet with my clock in and out times, the amount of...
  20. H

    If and with multiple conditions & cells

    Novice Excel user trying to figure out an if and formula <colgroup><col><col span="2"><col><col></colgroup><tbody> <tbody> BR CLOCK $2 BR CLOCK $2 BR TABLE $5 BR CHAIR $3 LV CLOCK $3 LV CLOCK $3 LV CLOCK $3 LV CLOCK $3 </tbody> </tbody> Essentially I am trying to say if...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top