Dear Experts,
Thanks for giving your valuable time.
The problem is that i have to prepare a summary of time-sheet based on the working hours (hours worked is based on time i.e. 04:00 - 08:00 & 13:00 - 17:00 etc.). It is really difficult for me to explain in here without attaching the file because it contains many columns, headings and formulas already.
The main thing i have to do is collect the data from 20-30 Worksheets of same excel file and paste/keep it as summary (name wise, employee code could be used) .
Many kind of calculation is done there to get the details already.
Some important conditions are as below:
1) If the working hours exceeds more than 8, a day, a person, then overtime should be added as 1.25% . For example, if a person works 10 hours in one day, overtime should be calculated 2*1.25 = 2.50 so the total hours worked for that day will be 10.50.
2) Friday is Holiday, If a person works on Friday then all the hours worked shall be treated as overtime with 1.50. Example, if a person worked 10 hour on Friday then the hours should be calculated as 10*1.50 = 15 hours. For the month of September, 5,12,19,26 are fridays.
Worse thing is that i have no idea about VBA.
I would be glad to send you the files in your email or any other media as per your suggestion. My email is raj_bhattarai2010@yahoo.com.
Your support could help me to save my hours and hours.
Thank you.
Thanks for giving your valuable time.
The problem is that i have to prepare a summary of time-sheet based on the working hours (hours worked is based on time i.e. 04:00 - 08:00 & 13:00 - 17:00 etc.). It is really difficult for me to explain in here without attaching the file because it contains many columns, headings and formulas already.
The main thing i have to do is collect the data from 20-30 Worksheets of same excel file and paste/keep it as summary (name wise, employee code could be used) .
Many kind of calculation is done there to get the details already.
Some important conditions are as below:
1) If the working hours exceeds more than 8, a day, a person, then overtime should be added as 1.25% . For example, if a person works 10 hours in one day, overtime should be calculated 2*1.25 = 2.50 so the total hours worked for that day will be 10.50.
2) Friday is Holiday, If a person works on Friday then all the hours worked shall be treated as overtime with 1.50. Example, if a person worked 10 hour on Friday then the hours should be calculated as 10*1.50 = 15 hours. For the month of September, 5,12,19,26 are fridays.
Worse thing is that i have no idea about VBA.
I would be glad to send you the files in your email or any other media as per your suggestion. My email is raj_bhattarai2010@yahoo.com.
Your support could help me to save my hours and hours.
Thank you.
