m17347047711116
New Member
- Joined
- Aug 28, 2002
- Messages
- 7
HAVE 1 COLUMN FOR START TIME
HAVE 7 ROWS FOR 7 EMPLOYEES
WANT TO ENTER THERE START TIME
EXAMPLE
NANCY----7:30 AM
TED------8:00 AM
BILLY----9:00 AM
I THEN WANT TO RUN A COUNT TO SEE HOW MANY PEOPLE ARE IN THE BUILDING EVERY 15 MINUTES
SO I SET UP A COLUMN WITH TIMES STARTING AT 5:00 AM
5:15 AM
5:30 AM
5:45 AM
AND SO ON DOWN TO 4:45 AM FOR A TOTAL OF 24 HOURS.
I THEN TRIED TO USE THE COUNT IF FUNCTION USING THE 7 START TIMES AS THE DATA AND THE 15 MINUTE TIMES FOR THE CRITERIA.
BUT I WILL NOT WORK IT ONLY WORKS FOR THE FIRST 7 15 MINUTE INTERVALS AFTER THAT NOTHING.
ANYONE KNOW OF ANOTHER WAY ????
HAVE 7 ROWS FOR 7 EMPLOYEES
WANT TO ENTER THERE START TIME
EXAMPLE
NANCY----7:30 AM
TED------8:00 AM
BILLY----9:00 AM
I THEN WANT TO RUN A COUNT TO SEE HOW MANY PEOPLE ARE IN THE BUILDING EVERY 15 MINUTES
SO I SET UP A COLUMN WITH TIMES STARTING AT 5:00 AM
5:15 AM
5:30 AM
5:45 AM
AND SO ON DOWN TO 4:45 AM FOR A TOTAL OF 24 HOURS.
I THEN TRIED TO USE THE COUNT IF FUNCTION USING THE 7 START TIMES AS THE DATA AND THE 15 MINUTE TIMES FOR THE CRITERIA.
BUT I WILL NOT WORK IT ONLY WORKS FOR THE FIRST 7 15 MINUTE INTERVALS AFTER THAT NOTHING.
ANYONE KNOW OF ANOTHER WAY ????