Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count number of shifts...
We currently have approx. 700 schedules in our scheduling software and
we often need to export them to count how many Mon - Fri, Tue - Sat, Sun - Thr shifts. Being a 24x7 operation, the combination of days worked vary alot. Ex. Mon, Tue, Fri, Sat, Sun. The format of our export is MTWRF--. Dashes always indicate days off. In addition, to count the number of 1st, 2nd, and 3rd shift schedules - an indicator accompanies each schedule. These are FT1, FT2, FT3, PT1, PT2, PT3. FT = Full Time (number = shift). I have tried IF statements, countif, etc... My problem is that there are so many variations of days off that I cannot place the logic in them. To further their complexity, some are Part Time and some work 5 x 8 schedules, others have 4 x 10's. Can anyone assist me some code or formula that will read: M--RFYS FT1 ---RFYS FT1 MTWRF-- FT3 -TWRF-- FT3 -T---YS PT2 and tell me that I have 2 Monday - Friday FT3 schedules / 2 double-day weekend FT1 schedules / 1 double-day PT2 schedule. We only need their Shift (FT1, PT1, etc.), single or double day weekend, or no weekend days (Mon - Fri) in the reports. Any and all help is appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Count number of times a specific number is displayed in cells | Excel Programming |