Hi there all....
Todays dilema is as follows:
i have various shifts on various cells through out my sheet.
d7 - 15:30
d8 - 06:00
d9 - 10:00
d13 - 07:30
d14 - 06:00
d15 - 08:00
I need to count how many fall within each range that i specify. For example between 06:00 - 08:00 the result should be 4
08:30 - 10:00 the result should be 1 etc
Ive tried to count frequency and countif but i cant seem to pinpoint the query above.
As usual any help is greatly appreciated.
Todays dilema is as follows:
i have various shifts on various cells through out my sheet.
d7 - 15:30
d8 - 06:00
d9 - 10:00
d13 - 07:30
d14 - 06:00
d15 - 08:00
I need to count how many fall within each range that i specify. For example between 06:00 - 08:00 the result should be 4
08:30 - 10:00 the result should be 1 etc
Ive tried to count frequency and countif but i cant seem to pinpoint the query above.
As usual any help is greatly appreciated.