I need to count records in each 8h (starting from first adequate hour) during day (6-22) and in each 0,5h (starting from first adequate hour) during night (22-6). For example if there is 21:50; 22:20; 22:25; 22:30; 22:50; 23:05; 23:15; 23:45 then the first adequate hour for night is 22:20 and from it I would have to start counting. Consequently I would have to count how many records is between 22:20 and 22:50; 22:50 and 23:20; 23:20 and 23:50.There is attached example https://rg.to/file/a5973758f63cc9f6c837303cd7162b77/example.xlsx.html solved for two days in K column. Could you please help me?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
counting numbers in different time intervals
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
OK.
Why is the result given as 88 for 6:15 - 14:15 ?
I can only see about 30 values in that range.
ALSO, I notice that you seem to have quite a few merged cells - what's going on with them ?
Why is the result given as 88 for 6:15 - 14:15 ?
I can only see about 30 values in that range.
ALSO, I notice that you seem to have quite a few merged cells - what's going on with them ?
Upvote
0
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I will type other data in this sheet. I merged cells because I know that sometimes I will need a place for more than one record. I can unmerge those cells but numbers of records can not change so there will be empty records under those specific cells that were previously merged. Also there should be about 30 values in that range I don't know why it isn't.
Upvote
0
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
OK, I'm not seeing anything that looks like an answer to my question
Upvote
0
Similar threads
- Question
- Question
