| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate # of days from two different times
If A1=Date Reported, B2=Date Resolved, B3=Resolution Period
What formular should I use to: 1) calculate the resolution period in days, excluding weekends and public holidays. 2) display "pending" in the Resolution Period cell if the Date Resolved cell does not have a time value 3) display "impossible" in the Resolution Period cell if the value in the Date Resolved Cell is less than the value in the Date reported cell 4) display "invalid" in the Resolution Period cell if either the Date Resolved Cell or the Date Reported cell has no values. Please assist... -- Fia Fiji Islands |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between dates/times in Days & Hours | Excel Discussion (Misc queries) | |||
| How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
| Difference in two times over days | Excel Worksheet Functions | |||
| find days and hours between 2 sets of dates and times | Excel Discussion (Misc queries) | |||
| Need to calulate a sum for once a month X #days X #times used per. | Excel Worksheet Functions | |||
Threaded Mode
