+ Reply to Thread
Results 1 to 3 of 3

Attendance Sheet - first in, last out

  1. 08-11-2020, 09:55 PM #1
    ElaineMok
    ElaineMok is offline
    Registered User
    Join Date
    03-26-2015
    Location
    SINGAPORE
    MS-Off Ver
    MS2013
    Posts
    56

    Attendance Sheet - first in, last out

    I need help to extract the first in and last out time in a attendance sheet and i also cannot seem to extract the temperature of the staff. Pl help.
    Thanks.
    Attached Files Attached Files
    Last edited by ElaineMok; 08-11-2020 at 10:30 PM.
    Reply With QuoteRegister To Reply
  2. 08-12-2020, 12:19 AM #2
    gak67
    gak67 is offline
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Attendance Sheet - first in, last out

    I'm not going to download a .zip file, and can't give specific advice without an example, but maybe a MAX(IF combo as an array formula for the last sign out (and MIN(IF combo for tht first sign in) would work.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.
    Reply With QuoteRegister To Reply
  3. 08-12-2020, 12:22 AM #3
    Phuocam
    Phuocam is online now
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,913

    Re: Attendance Sheet - first in, last out

    Duplicate thread in commercial services.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Track attendance points for a rolling year with point drop off for perfect attendance
    By dardziad in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-30-2020, 11:37 PM
  2. Creating a tracking sheet for attendance for the year each month is on it's own sheet
    By sandiandrae in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-18-2016, 07:25 PM
  3. Attendance System that Adds Point For the Month and Subtracts Points if Perfect Attendance
    By MinieMe209 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  4. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  5. How to create Login & Log out Spread sheet in Excel with automated Attendance sheet
    By moses4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2014, 12:29 PM
  6. [SOLVED] Copying data from a certain sheet to another sheet for attendance in VB
    By blueswan in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 06-20-2012, 07:08 AM
  7. attendance sheet
    By may HS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2005, 02:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1