Countif between 6 am & 2 pm
I need to count the number of times on several dates (on the same row as the time) there are between 6 am & 2 pm; 2pm to 10 pm; 10 pm to 6 am.
E.G. Row 111 column B-7-31-10 column c-11:55 pm would count as 1. I am counting the number of assessments done per shift. |
Quote:
=IF(AND(Assessment time taken=6am, Assessment time taken<=2pm),1,0) Then count all cells that have values of 1. |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com