| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
picking out date ranges
Hi everybody
I have a list of Names and dates in col A and start and end times in col b and c and Names in col Q, I have worked out this "=SUM(IF($A$1:$A$13562=$Q$4,$C$1:$C$13562-$B$1:$B$13562))" to find out how long we have spent at a given name down the whole of col a, I would like to be able to set a stert date and end date so that it will only return the time spent at a given name between the dates I enter???? eg Col a b c q r 31/03/05 Baker 06:00 06:30 Baker 00:30 Smith 07:00 08:00 Smith 03:00 Jones 00:10 05/04/05 Smith 08:00 09:00 Jones 10:50 11:00 06/04/05 Smith 08:00 08:30 07/04/05 Smith 08:00 08:30 How could I sum the times in b & c between say 05/04/05 and 07/04/05 ??? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
| Conditional formatting date ranges | Excel Worksheet Functions | |||
| Assigning consecutive date ranges | Excel Worksheet Functions | |||
| macro to change date ranges | Excel Discussion (Misc queries) | |||
| count date ranges | Excel Worksheet Functions | |||
Threaded Mode
