| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count times between 2 times and 2 dates
And if we don't want to count only unique "Control # - Date"'s
just remove this condition from the formula: .. (H2:H100="x")* .. viz., use: In I2: =SUMPRODUCT((WEEKDAY(D2:D100)=1)* (D2:D100= --"1-Jan-2006")*(D2:D100<= --"31-Mar-2006")) In J2: =SUMPRODUCT((E2:E100= "0000")*(E2:E100<="0400")* (D2:D100= --"1-Jan-2006")*(D2:D100<= --"31-Mar-2006")) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
| Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Threaded Mode
