+ Reply to Thread
Results 1 to 2 of 2

Computing turnaround time down to minutes/seconds

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Computing turnaround time down to minutes/seconds

    I'm trying to compute the turnaround time of my transactions using networkdays. I need to show the result in a h:mm:ss time format.
    So far, I have this formula: =NETWORKDAYS(G2,H2,Holidays)-1-MOD(G2,1)+MOD(H2,1)
    But it can't capture some items that are only a few minutes/seconds apart.

    Ex.
    Start date: 4/6/2014 19:09
    End date: 4/6/2014 19:13

    With my current formula, the result shows only #########

    It seems for work on other entries but not for the dates like the example above & I can't figure out why that is. Any ideas on how to fix this?

    Thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,084

    Re: Computing turnaround time down to minutes/seconds

    It would probably help if you posted a sample workbook.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Cant get the minutes in computing this time stamp
    By ragnakistah in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-23-2013, 12:32 PM
  2. Help computing turnaround time for night shift
    By hypothetical in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2013, 10:37 AM
  3. Understanding time (minutes:seconds)
    By jonasmacs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2012, 06:09 AM
  4. Adding Time, Minutes & Seconds
    By critter4511 in forum Excel General
    Replies: 6
    Last Post: 04-03-2012, 06:41 PM
  5. Extract Minutes and Seconds from a time value
    By purdue7997 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2009, 09:28 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