+ Reply to Thread
Results 1 to 4 of 4

ticket ageing in excel

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Manila
    MS-Off Ver
    Excel 2010
    Posts
    4

    ticket ageing in excel

    new to the forum and definitely no expert on excel.. hope you guys can help..

    while looking for a way to determine ageing of tickets, i stumbled upon this thread http://www.excelforum.com/excel-gene...ing-hours.html which is similar to my concern except that for my case there are no working times (e.g. 8am-5pm). the tickets can and should be finished regardless whether it's passed 5pm

    for example: "ticket created = Apr23 12:00" and "current time is Apr24 14:00", how can i arrive at "age of ticket = 26 hrs"?

    again, my apologies for my very limited knowledge in excel.. thanks in advance for your help..
    Last edited by allen1968; 04-24-2013 at 09:12 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: please help / ticket ageing in excel

    Hi Allen,

    here's a way to do it.
    A1: date for ticket created
    B1: current time (can be displayed with =NOW() function)
    C1: =B1-A1 (set cell format to custom [h]:mm )

  3. #3
    Registered User
    Join Date
    04-23-2013
    Location
    Manila
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: please help / ticket ageing in excel

    wow! thanks so much! didn't know it was that simple highly appreciate your help!

  4. #4
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: please help / ticket ageing in excel

    Glad to help.

    Please mark the thread SOLVED to comply with forum rules. (And to please the moderators. :P)

+ 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