Results 1 to 4 of 4

ticket ageing in excel

Threaded View

allen1968 ticket ageing in excel 04-24-2013, 03:27 AM
RHCPgergo Re: please help / ticket... 04-24-2013, 03:55 AM
allen1968 Re: please help / ticket... 04-24-2013, 04:12 AM
RHCPgergo Re: please help / ticket... 04-24-2013, 05:56 AM
  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.

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