Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |