+ Reply to Thread
Results 1 to 9 of 9

How to arrange attendance table?

  1. #1
    Registered User
    Join Date
    02-20-2021
    Location
    US
    MS-Off Ver
    2019
    Posts
    54

    How to arrange attendance table?

    Dear Experts,

    I have the time record report from the system and that report showing the individual staffs clock in and out in each day.
    However, clock log report is not arranging properly which I don't know whether the staff come to work late or late after coming from break time etc.

    I have attached the file. And in that excel file you will see "Table 1" which is the time record/clock log from the system and "Table 2" is the result that I wanted.

    Thank you!

    Regards,
    Manith
    Attached Files Attached Files
    Last edited by Manith; 06-12-2024 at 07:19 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,680

    Re: How to arrange attendance table?

    Are you still using Excel 2019?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-20-2021
    Location
    US
    MS-Off Ver
    2019
    Posts
    54
    Quote Originally Posted by TMS View Post
    Are you still using Excel 2019?
    Hello!
    Yes I am using excel 2019. If possible can have both solution for excel 2019 and 2021?

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,680

    Re: How to arrange attendance table?

    Ah. Probably not from me.

  5. #5
    Registered User
    Join Date
    02-20-2021
    Location
    US
    MS-Off Ver
    2019
    Posts
    54

    Re: How to arrange attendance table?

    Also can be excel 2021 but i'm not using the office 365.
    Or possible with VBA, Sir?

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,772

    Re: How to arrange attendance table?

    Check this please...

    How you can tell when Bobby on 12.05. took the break?

    14:55 - 17:35 or 17:35 - 18:30?

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-20-2021
    Location
    US
    MS-Off Ver
    2019
    Posts
    54

    Re: How to arrange attendance table?

    Hello Sir,
    Because the breaktime is 1hr.
    Bobby 12.5.2024 13:00
    Bobby 12.5.2024 14:55 This consider as faulty and cannot consider that staff take break after working only 1h55mn.
    Bobby 12.5.2024 17:35 (clock out for breaktime)
    Bobby 12.5.2024 18:30 (Clock in for breaktime)
    Bobby 12.5.2024 22:07

    And ur VBA look great, but only if got time record as 12-5

    Thank you

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,772

    Re: How to arrange attendance table?

    Fixed.
    It should look now what value is closer to 1 hour (break time) meaning it should ignore false entries.
    Attached Files Attached Files
    Last edited by zbor; 06-13-2024 at 09:07 AM.

  9. #9
    Registered User
    Join Date
    02-20-2021
    Location
    US
    MS-Off Ver
    2019
    Posts
    54

    Re: How to arrange attendance table?

    Quote Originally Posted by zbor View Post
    Fixed.
    It should look now what value is closer to 1 hour (break time) meaning it should ignore false entries.
    Hello Sir,
    It works perfectly.
    Thank you so much!

+ 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. Arrange numbers in table
    By issa.o in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-31-2022, 01:18 AM
  2. Formular to arrange time table
    By issa.o in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-17-2022, 02:31 AM
  3. Re-Arrange Table Data
    By dtpunshon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2021, 06:13 PM
  4. [SOLVED] Arrange data without using pivot table
    By jeanemik in forum Excel General
    Replies: 7
    Last Post: 12-08-2017, 04:29 AM
  5. [SOLVED] seating for the dinner table arrange
    By SelinaT in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2017, 02:52 AM
  6. How to arrange Data thanks to a Pivot Table
    By Yomdi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-04-2015, 02:43 PM
  7. [SOLVED] Arrange data from table
    By atlant15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 11:48 AM

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