+ Reply to Thread
Results 1 to 1 of 1

Calculating time difference

  1. #1
    Forum Contributor
    Join Date
    montreal, canada
    MS-Off Ver
    Excel 2003

    Calculating time difference

    I searched this forum for solved threads regarding the same type of problem.
    Unfortunatly, all the threads had different formatting, and I'm afraid I don't thouroughly understand all the forumulas involved.

    Anyways, the problem is quite simple:

    Ticket open ------------------ Ticket close
    2009-07-22 11:35:00 ----- 2009-07-28 08:43:00

    I need a response time calculated in hours.
    I can only get a response within 24hrs.
    Ticket dates and times come out in the same cell when I copy paste from my other software.

    EDIT: FORGET ABOUT IT: [H]:mm:ss
    Got it...
    Attached Files Attached Files
    Last edited by Sibrulotte; 07-28-2009 at 09:17 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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