Results 1 to 9 of 9

Need Help Capturing Night Shift and login Hrs.

Threaded View

KARTHICKNAIDU Need Help Capturing Night... 03-08-2016, 03:27 PM
shknbk2 Re: Need Help Capturing Night... 03-08-2016, 04:13 PM
KARTHICKNAIDU Re: Need Help Capturing Night... 03-08-2016, 05:02 PM
shknbk2 Re: Need Help Capturing Night... 03-08-2016, 05:16 PM
KARTHICKNAIDU Re: Need Help Capturing Night... 03-08-2016, 05:57 PM
shknbk2 Re: Need Help Capturing Night... 03-08-2016, 06:12 PM
KARTHICKNAIDU Re: Need Help Capturing Night... 03-08-2016, 06:41 PM
shknbk2 Re: Need Help Capturing Night... 03-08-2016, 06:59 PM
KARTHICKNAIDU Re: Need Help Capturing Night... 03-27-2016, 08:15 PM
  1. 03-08-2016, 03:27 PM #1
    KARTHICKNAIDU is offline
    Registered User
    Join Date
    09-21-2015
    Location
    Indore
    MS-Off Ver
    Windows 8
    Posts
    18

    Need Help Capturing Night Shift and login Hrs.

    Hi,

    I have a list of Employees and their login, log out date & time. Difference between logout time and login time will give me Login Hrs. Problem is, for one Employee I have multiple readings within the shift time and for night shift agents I'm unable to get 01st login and last logout. Can anyone help me with VBA or formula to get first login, last logout and their login hrs details.

    Thanks in Advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. day shift overtime and night shift formulas
    By Pranklin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2015, 04:05 PM
  2. Caculating # of Day Shift Hrs & Night Shift Hrs of a Given Shift
    By DaKhoda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2014, 08:36 PM
  3. Need Help on Time Sheet Formula (Day Shift OK/Night Shift=Problem)
    By jomapac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2013, 02:26 AM
  4. [SOLVED] Spliting Day Shift and Night Shift Hours
    By Goldbadger2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2013, 01:16 AM
  5. Overtime for Day Shift & Night Shift matching with Mon-Fri,Sat(half day) and Sun
    By yen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 08:29 PM
  6. Calculate night shift hours worked - working hours span the night shift start and end
    By Gratch in forum Excel General
    Replies: 4
    Last Post: 09-21-2012, 12:58 AM
  7. Day shift/night shift time calculation issue
    By STATEXCEL in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-31-2007, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1