+ Reply to Thread
Results 1 to 4 of 4

Date/Time Comparison

  1. #1
    Registered User
    Join Date
    08-01-2005
    Posts
    14

    Date/Time Comparison

    Having problems getting the following scenerio working.
    I am needing to compare a date specified in cell (x) with "NOW" and if it is greater than 10 minutes enter "2" in cell (y).

    Attached is a example of what I am looking to do, it is a bit flacky on the calculations of time but I think you can determine what I am looking to do.

    What needs to happen is if it is an "Urgent" and in "Work In Progress" and has not been modified for 1 - 2 days enter "2' in column P. If it is in that status for more than 2 days then enter "3"

    Also will need to do the same type of thing for tickets that are not urgent but have not been modified for 10 minutes.

    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Perhaps something like this for row 2:

    =IF(NOW()-K2>TIME(0,10,0),2,"Ok")

    you can replace "Ok" with whatever you want to return if within 10 minutes.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-01-2005
    Posts
    14
    Thanks for that formula, it works for another area I was working with but in this case it needs to be more complex.

    So it needs to go through a list of Tickets and verify the following:

    If the ticket is Urgent and the status is Assigned - Enter "1" in Column "P"
    If it is Urgent and the status is WIP between 1 - 2 days - Enter "2" in "P"
    If it is Urgent and the status is WIP >2 days or Pending status - Enter "3" in "P".

    I am having problems with creating a VBA Script to do this, I think my problems lay in the date/time area.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Not sure why you need VBA....

    possibly a formula like this in P2 copied down?

    Please Login or Register  to view this content.

+ 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