+ Reply to Thread
Results 1 to 2 of 2

Calculate time elapsed or worked during (eg) 12:01am to 6:00am

  1. #1
    Registered User
    Join Date
    12-26-2003
    Posts
    3

    Calculate time elapsed or worked during (eg) 12:01am to 6:00am

    I'm trying to calculate the time worked between 12:00am to 6:00am (early morning).

    My data is simply from a data log (for an over the road {OTR} truck driver). What makes it a bit complicated is OTR drivers can work any time period during 24 hour period:
    Examples:
    A2 04/02/2016 22:10 ON (where A2 contains date+ time in the cell)
    A3 04/03/2016 08:10 Off
    A4 04/03/2016 20:00 ON
    A5 04/04/2016 03:00 Off

    Between A2 & A3 the driver worked 10 hours; 6 hours during early morning
    Between A4 & A5 he driver worked 7 hours; 3 hours during early morning

    Hours worked is simple subtraction but I've run into problems (cranial limitations!!) on solving the early morning calculation. Any suggestions?
    Thanks
    Last edited by rdy4trvl; 05-29-2016 at 07:56 PM. Reason: grammatical

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Calculate time elapsed or worked during (eg) 12:01am to 6:00am

    With A2 is ON time, A3 is OFF time

    Hours within 0-6:00 AM:

    =MIN(INT(A3)+6/24,A3)-MAX(INT(A3),A2)
    Quang PT

+ 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: 7
    Last Post: 04-25-2020, 03:23 AM
  2. Need to calculate elapsed time, but excel won't recognize the format as time.
    By sccrfraggle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2015, 10:49 PM
  3. Calculate time elapsed, excluding time not spent working
    By BREECHEEZ87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2015, 03:01 PM
  4. Can't seem to calculate elapsed time?
    By homer09001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2013, 08:12 AM
  5. Replies: 2
    Last Post: 04-27-2011, 08:21 AM
  6. Calculate elapsed time by now() ?
    By Desiv5 in forum Excel General
    Replies: 5
    Last Post: 05-07-2010, 05:16 AM
  7. calculate elapsed time
    By Tiresias in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2008, 12:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1