+ Reply to Thread
Results 1 to 3 of 3

Determine Duration between Start Time and End Time Taking into consideration shift hours

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    108

    Determine Duration between Start Time and End Time Taking into consideration shift hours

    Hello Experts!

    I have a start time and end time and I want to compute for the duration only within our shift hours.

    Shift Start: 08:00 PM
    Shift End: 5:00 AM (the next day)

    Example 01

    Start Time: 07/13/2015 03:30 AM
    End Time: 07/14/2015 09:25 PM

    With the above example the duration should be computed 1st from 07/13/2015 03:30 AM to 07/13/2015 05:00 AM which is 1:30 hours and 2nd from 07/14/2015 08:00 PM to 07/14/2015 09:25 PM which is 1:25 and if we total the 1:30 and 1:25 we will have 2:55 as the duration.

    Example 02

    Start Time: 07/13/2015 08:30 PM
    End Time: 07/14/2015 01:00 AM

    Since the above example is within the shift the duration is 4:30.

    Thank you
    Hudas

  2. #2
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    Re: Determine Duration between Start Time and End Time Taking into consideration shift hou

    Can you post a mock up sample file please, remove sensitive Data 1st

  3. #3
    Forum Contributor
    Join Date
    02-16-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    108

    Re: Determine Duration between Start Time and End Time Taking into consideration shift hou

    Shift Start Date 8:00:00 PM
    Shift End Date 5:00:00 AM (the next day)

    Start Time End Time Duration
    07/15/2015 1:14:34 AM 07/16/2015 9:44:34 PM
    07/15/2015 1:51:37 AM 07/15/2015 4:58:37 AM
    07/15/2015 8:00:34 PM 07/15/2015 11:01:39 PM

    The Time duration from 5:00:01 AM to 7:59:59 PM should not be included in the computation. I've tried to attached a file but i'm having some network issues.

    Thank you
    Hudas

+ 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. Replies: 10
    Last Post: 11-08-2014, 04:51 PM
  2. Adding up Absent time taking lunch time into consideration
    By abrilabs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2013, 02:02 PM
  3. Replies: 21
    Last Post: 11-30-2012, 07:28 PM
  4. Calculate finish time given start time, working hours and job duration
    By swanseaexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 03:00 PM
  5. Calculating END time based on start time, breaks, and hours to complete
    By sweedey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2012, 11:29 AM
  6. Replies: 5
    Last Post: 02-19-2009, 01:41 PM
  7. [SOLVED] template or formula for start time -finish time -total hours ple
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-27-2006, 01:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1