+ 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 2003,2007,2010
    Posts
    30,040

    Re: Computing turnaround time down to minutes/seconds

    It would probably help if you posted a sample workbook.
    Trevor Shuttleworth - Excel Aid

    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)

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