PC Review


Reply
Thread Tools Rate Thread

Compare dates based on statuses & work out whether achieved on tim

 
 
=?Utf-8?B?S2llcmFubw==?=
Guest
Posts: n/a
 
      17th Oct 2006
I have 3 columns:

Column 1 has 'date submitted'
Column 2 has status e.g. urgent, high, medium, low
Column 3 has 'date implemented'

The statuses in column 2 have values, e.g. Urgent = 2 days, High = 5 days,
Medium = 10 days, Low = >10 days

I need to be able to establish whether statuses were adhered to, e.g. if a
task was urgent, was it completed within 2 days; if a task was high, was it
completed within 5 days.

Thanks in advance.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to delete rows based based between two specific dates Trey24 Microsoft Excel Misc 0 25th Aug 2009 05:05 PM
compare 2 tables of dates to find the preceding dates Babi Microsoft Excel Worksheet Functions 3 28th Oct 2008 05:52 AM
Calculate minutes between dates based on 9hr work days JQS Microsoft Excel Worksheet Functions 1 3rd Sep 2008 09:14 AM
Compare multiple dates, can enumerate cell based on most recent date Brian Microsoft Excel Worksheet Functions 7 9th May 2006 11:02 PM
GPRS statuses Antony Daugh Microsoft Dot NET Compact Framework 4 6th Apr 2004 09:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:35 PM.