Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

2012-04-03 Thread Darwin Chan
-macros@googlegroups.com > *Sent:* Tuesday, April 3, 2012 12:02 PM > *Subject:* $$Excel-Macros$$ To calculate the maximum and minimum > appearance in Staff Roster Plan > > Dear all, > > I have a roster with staff allocated on different roster plan, i.e. > different working hour

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

2012-04-03 Thread pawel lupinski
I realy don't know what are you looking for so check if this is what you are looking for.   Regards,   Pawel From: Darwin Chan To: excel-macros@googlegroups.com Sent: Tuesday, April 3, 2012 12:02 PM Subject: $$Excel-Macros$$ To calculate the maximu

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

2012-04-03 Thread anil panchal
Dear Darwin, Please find the attached file. {I am not understant exact wt you want in from time & please revert me with sample like count or sum total working hours ) Thanks & Regards Anil Kumar 113784 On Tue, Apr 3, 2012 at 4:32 PM, Darwin Chan wrote: > Dear all, > > I have a roster

$$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

2012-04-03 Thread Darwin Chan
Dear all, I have a roster with staff allocated on different roster plan, i.e. different working hours. I have a task to analyse the maximum and minimum of staff who would appear at concurrent period. However, volume of data is huge and formula is needed for assistance in analysis. I have atta