| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
counting time slots
hi there, still having trouble with this, i am trying to work out the correct
formula to give me a head count from my excel based staff rota, the layout is below, what i need to count is the number of people at work between 07:00 and 08:00, 08:00 and 09:00 and so on. 06:00 1 15:00 09:00 1 15:00 07:00 1 16:00 07:00 1 15:00 09:00 1 15:00 11:00 1 17:00 thanks for any help you can give me :) |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(A1:A10<=--"07:00"),--(C1:C10--"08:00"),B1:B10)
-- HTH RP (remove nothere from the email address if mailing direct) "Nick" wrote in message ... hi there, still having trouble with this, i am trying to work out the correct formula to give me a head count from my excel based staff rota, the layout is below, what i need to count is the number of people at work between 07:00 and 08:00, 08:00 and 09:00 and so on. 06:00 1 15:00 09:00 1 15:00 07:00 1 16:00 07:00 1 15:00 09:00 1 15:00 11:00 1 17:00 thanks for any help you can give me :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Cells with time value | Excel Discussion (Misc queries) | |||
| Summing Time | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
