+ Reply to Thread
Results 1 to 4 of 4

total time

Hybrid View

  1. #1
    Registered User
    Join Date
    11-17-2007
    Posts
    28

    total time

    I have this setup

    (H) "Dispatch Start Date" (MM/DD/YYYY)
    (I) "Dispatch Start Time" (HH:MM)
    (J) "Closed Date" (MM/DD/YYYY)
    (K) "Closed Time" (HH:MM)
    (L) "Elapsed Time" (HH:MM)

    I need to find the total time spent on a job, some jobs are worked from one day to another,

    example:

    (H) "Dispatch Start Date" 01/01/2008
    (I) "Dispatch Start Time" 20:15
    (J) "Closed Date" 01/02/2008
    (K) "Closed Time" 06:00
    (L) "Elapsed Time" 9:45

    Thanks in advance

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    =j1+k1-h1-i1

  3. #3
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Hi,

    This link can also be usefull if you are looking for something other than the total number of hours elapsed between 2 dates.

    http://www.cpearson.com/excel/DateTimeWS.htm
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

  4. #4
    Registered User
    Join Date
    11-17-2007
    Posts
    28
    Got it thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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