LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Calculating whether solution is in time or not

Dear Excel(lent) users,

I have a list in which al sent requests are logged. Every request has a
priority, each priority defines in what time a request needs to be executed.

To clarify:
In Column A I use the date of the sent request
In Column B I use the date of the request being executed
In Column C I use the priority of the request

Column A Column B Column C
-------------- ------------- ----------
01-01-2008 02-01-2008 1
01-02-2008 02-02-2008 2
01-03-2008 02-03-2008 3
01-04-2008 08-04-2008 1
01-04-2008 08-05-2008 4
01-04-2008 08-06-2008 5


If you take the following maximum processing time into consideration:

Priority max days to process
-------- -----------------------
1 1
2 2
3 5
4 10
5 15

I am looking for a formula which would give me the following information:

Priority Deadline met Deadline not met
-------- --------------- --------------------
1 1 1
2 1 0
3 1 0
4 0 1
5 0 1


Can you please help me ??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Time with Date/Time checking in formula cmatera Excel Worksheet Functions 2 August 11th 08 01:38 PM
Calculating Regular time, overtime and double time Brian Smith Excel Worksheet Functions 5 November 9th 07 10:32 PM
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 03:45 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 03:50 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"