Help: In applying the Concatenate formula in VBA string

[Manish Kumawat]

Hi Hui Sir,

I have an attendance sheet which i need to print with certain criteria for this i have use some code for Page break, Inserting some text string below Early time.

But I have stuck somewhere and need your help for this.

1. I need dates of no punch in a particular format calculated for each attendance by using concatenate formula so that the dates can be assemble in single cell.

2. Same condition for Dates of no out punch (Dates)

3. Same condition for dates of Early out (Date)

4. Same condition for Late in ( Dates)

You can see the strict official timings are 9.30 AM for in Punch and 5.30 PM for out Punch for Monday to Friday and 9.30 AM to 1.30 PM for Saturdays.

Please help me in this regard as i am very keen to learn the new concepts of VBA and advanced excel.


Thank you in anticipation

Regards

Manish

 

[Manish Kumawat]

Can anyone help me

Thanks
Manish