beh162
New member
- Joined
- Jan 15, 2015
- Messages
- 7
- Reaction score
- 0
- Points
- 0
im trying to figure out how to write out the proper countif
The formula is needed in the Lines tab B8:B38. The range is in the schedule tab B8:B33 for in time. C8:C33 out time.
In the schedule tab I have Cashier's schedules I want to be able to have their schedules tally in the Lines tab. So if there is a cashier working 8-4:30 I want there to be a tally in the lines sheet from 8:30AM to 4:45pm (Always stops 15 minutes before the end of their shift in this case stop at 4:30). That would continue for every time listed.
I have this formula in there and it seems to work but I know it's very basic to that first time, not sure what you would do for the next increment of time since it will need to include the previous time as long as the shift didn't end.
=COUNTIF(Schedule!B8:B33,"8:30")
And how do I get it to fill all the way down stopping at 4:30 for the 8a-5p example I used above.
The formula is needed in the Lines tab B8:B38. The range is in the schedule tab B8:B33 for in time. C8:C33 out time.
In the schedule tab I have Cashier's schedules I want to be able to have their schedules tally in the Lines tab. So if there is a cashier working 8-4:30 I want there to be a tally in the lines sheet from 8:30AM to 4:45pm (Always stops 15 minutes before the end of their shift in this case stop at 4:30). That would continue for every time listed.
I have this formula in there and it seems to work but I know it's very basic to that first time, not sure what you would do for the next increment of time since it will need to include the previous time as long as the shift didn't end.
=COUNTIF(Schedule!B8:B33,"8:30")
And how do I get it to fill all the way down stopping at 4:30 for the 8a-5p example I used above.