DesperateIntern
New member
- Joined
- Nov 16, 2016
- Messages
- 6
- Reaction score
- 0
- Points
- 0
PV Stands for Personal Vehicle. There are Four Sub-Systems in each PV. (C952), (C951), (C960) & (Train ATS).
The Cells Highlighted Bright Red & Neon Pink are Repeated Dates within the PV. The Macro is only able to Avoid counting them in "Total Duration" ( Image Below )
However the highlighted Grey Cells that have repeated dates in different PV will still count them.
The Macro is in the File "Neo Data Summary", Open together with "CheckList Dump". Then Run the Macro to understand what i meant.
My point is, the supposed value for "Total Amount of Duration" Should be 20 Days instead. But because it counts ( 6/11/2015 ) as a separate date from different PVs, it becomes 21 Days.
View attachment Checklist Dump.xlsx
View attachment Neo Data Summary.xlsm