+ Reply to Thread
Results 1 to 15 of 15

Missing Clock in and Out Maco

  1. #1
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Missing Clock in and Out Maco

    Hello,

    We are working with a finger print clock in and out maching but sometimes employees forget to clock in or out.

    I would like to create a macro to be able to fix it.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Missing Clock in and Out Maco

    Hi, welcome to the forum, since it's your first post (at least here) I understand that you might think that a few words are sufficient for us to understand your entire issue.
    I suggest you explain it in a way others that have no idea what you're trying to do can understand it too.
    You know, guessing is not an option in these cases and time is valuable to many of us and not first need to figure out what an OP is asking and base answers on assumptions.
    Maybe the file explains it, but the post doesn't, try again, please
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Missing Clock in and Out Maco

    Paste code into a module.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    Hello Keebellah.

    Im sorry. What I am trying to do is create a Macro to fix the timesheets, if you see the spreadsheet sometimes the employee forgot to press the right button (in or out) So it takes me time to fix the timesheet everytime they forget to clock in or our. Also when the press In instead of out. Or maybe have all the times below the date instead of the way it is right now

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Missing Clock in and Out Maco

    You've got torachan's macro, what more do you need?
    BTW why are you using xls files?

  6. #6
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    I tried to do it but it did not work

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Missing Clock in and Out Maco

    Works for me, If I insert the macro and run it it marks those records with missing In and Missing OUT

  8. #8
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    Can you explain to me how to run a macro? I'm probably doing something wrong

  9. #9
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    Actually, It is possible to convert the spreadsheet to something like this? That way I can create a pivot
    Attachment 706910

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Missing Clock in and Out Maco

    Would you please attach the file in the indicated manner?
    I placed the macro in the file
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    Oh, thanks. That's exactly what I needed.

    Also, do you know how can I add I default time in case the employees forget to clock in or out?

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Missing Clock in and Out Maco

    You code it in the macro, and you will have to figure out what the time is you want to enter.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    either will work

  13. #13
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    How can you guys use power pivot and how to download it in Mac and PC Excel 2018

  14. #14
    Registered User
    Join Date
    12-01-2020
    Location
    US
    MS-Off Ver
    10
    Posts
    23

    Re: Missing Clock in and Out Maco

    Hey Guys!

    There is a possibility of sharing a Macro of my personal folder without sending my whole folder?

  15. #15
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Missing Clock in and Out Maco

    I don't understand your question.
    But if it's just one macro form your VBAProject, you can select the text of that macro and place within code tags in your post

    Please Login or Register  to view this content.
    You're acquainted with the forum rules and it's explained if you read the banner.
    If you want to export the entire module you can also do this but then attach the resulting bas file a s a zipped file because the bas extension is not recognized or accepted
    Hope my explanation makes sense

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-21-2020, 01:33 PM
  2. Simple Clock In/Clock Out hours tracker
    By dawilliams00 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-09-2020, 07:04 AM
  3. [SOLVED] Consolidating 2 data sets into a table to show a difference in clock in/clock out times
    By Buzz1126 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-24-2019, 10:09 AM
  4. Replies: 5
    Last Post: 07-17-2017, 12:44 PM
  5. [SOLVED] Calculating Allocated Hours Based On Clock In and Clock Out
    By rahul_ferns76 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-15-2016, 07:46 AM
  6. Pivot maco
    By Jack40 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2014, 05:24 PM
  7. [SOLVED] Start Clock/Stop Clock
    By abfabrob in forum Excel General
    Replies: 9
    Last Post: 06-28-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1