+ Reply to Thread
Results 1 to 2 of 2

How to check if a 2 specific time falls in between 2 times (Shifts) in Excel?

  1. #1
    Registered User
    Join Date
    03-03-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    1

    How to check if a 2 specific time falls in between 2 times (Shifts) in Excel?

    1.I want to find out if an event with start time and end time falls "inside" or "Outside" working shifts for associates.

    2.Segregate and calculate the production duration that falls within shift hours or outside shift hours.

    (The Shift timings are 5pm to 2am which would be the next day so that is something to look out of for.)

    In the attached image you can see that Row 2 : Stamp_IST is the starting time and Stamps_IST End is the end of that event (Production Hrs),

    For example in row 6 the user starts his production inside shift 1:24:37 AM but ends his production outside shift 3:36:02 AM so ideally he has worked only for around 6 mins within his shift and only duration of 6 mins to be taken in account where as the rest of the duration should fall outside shift. so is there a way formula or a macro which would segregate give me the duration spent within and outside shift hrs.


    [ATTACH]6884Timings doubt 3.png

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello athishvikram,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. How To Check If Time Is Between Two Times In Excel?
    By elokaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2020, 06:00 PM
  2. Check if the in and out time falls between a specific time interval
    By srivibish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2020, 03:18 AM
  3. determine if any time between two dates/times falls outside of hours
    By alaw0905 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2020, 04:18 PM
  4. [SOLVED] Determine if shift start/end time falls between times over 24h - more complex
    By annazet in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2019, 01:10 PM
  5. Replies: 1
    Last Post: 07-23-2019, 11:09 AM
  6. Replies: 1
    Last Post: 07-23-2019, 05:17 AM
  7. check in which range a date falls and return a specific value
    By beltzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2016, 04:29 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