Results 1 to 7 of 7

Time overlap

Threaded View

  1. 09-14-2015, 10:18 PM #1
    aanaduta
    aanaduta is offline
    Registered User
    Join Date
    04-07-2014
    Location
    melbourne
    MS-Off Ver
    Excel 2010
    Posts
    18

    Time overlap

    Hi Guys,
    I need to find out from big data set if someone actually clocked on to the job at the same time before he/she clocked off the previous job. I attached the data set for your information. Can you please help? is there a quick way by creating a formula to review the data set?

    Thanks a lot
    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. [SOLVED] Overlap between two time ranges
    By LondonJames in forum Excel General
    Replies: 11
    Last Post: 07-12-2019, 02:18 AM
  2. Time Overlap loop
    By Krix in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2015, 02:02 AM
  3. [SOLVED] Overlap for Date/Time
    By Brawnystaff in forum Excel General
    Replies: 2
    Last Post: 06-19-2015, 10:35 PM
  4. Calculating time overlap
    By T_Dawg in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-23-2015, 01:11 AM
  5. Time overlap %
    By sfire184 in forum Excel General
    Replies: 5
    Last Post: 09-09-2014, 02:23 AM
  6. [SOLVED] determine total overlap time when there are gaps in overlap (4 date ranges)
    By miriambender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 11:58 PM
  7. Plotting where overlap, find each overlap in a month, divide by # overlaps = total hours
    By kilbey1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2013, 11:21 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