Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Difference between two times - to the second

    I am trying to calculate the difference between two times to the second and am having difficulty.
    The object is to see how long it takes to process a report. That is the time it starts to when it prints.

    Start Print Duration
    05:00:03 05:06:37 #VALUE!
    05:06:37 05:09:39 ??????

    I am using Excel 2010.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You should be able to just subtract the first column from the second
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,168
    Thanks
    47
    Thanked 978 Times in 908 Posts
    Excel treat 1 day as the number 1, so 1 second is 1/(60*60*24).
    You could subtract one from the other and multiply by 86400, formatted as a number, or do as rory suggests and format as seconds.

    cheers, Paul

  4. #4
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Dallas, Texas, USA
    Posts
    113
    Thanks
    3
    Thanked 6 Times in 6 Posts
    Do the math, as initially suggested, and format the answer with hh:mm:ss.
    David Gray, Chief Wizard
    WizardWrx
    Irving, Texas, USA

    WizardWrx Web - Technical Articles and Free Software
    You are more important than any technology we may employ.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •