• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Employee Working days caculation

Dear Sir,

I want to create salary report for the month,

Please refer attached excel for your kind perusal.
 

Attachments

  • Salary Cal Formula.xlsx
    9.9 KB · Views: 2
Dear Sir, Nice formula its exactly meeting my requirement., can u please teach me *1+OR(G6>10.05,G7<6.3)*0.5)) impact of *1 & *0.5.
 
1 is for full day & .5 for half day.
But copied the formula in wrong way.
For better understanding u can get it with evaluate option.
Let me know if still any assistance is required.
 
Dear Sir,

Sorry to ask you again, if INTIME is after 2.00 then show 0 and if in time and out time is blank or zero should show zero. please make it into same formula.
 
Check this..

=IF(OR(COUNTA(B6:B7)<>2,AND(B6<10.05,B6>=2)),0,IF(OR(B6="WO",AND(B4="*",B6>10.05,B7>=6.3),AND(B6<=10.05,B7>=6.3)),1,OR(B6>10.05,B7<6.3)*0.5))
 
Dear Sir,
Sorry It didnt work, can you please look into the attached file.
I want result in yellow highlighted cell,system is calculating 2 clock = 14 please do accordingly and thanks a lot for your help.
 

Attachments

  • Sarfraz Salarly.xlsx
    10.5 KB · Views: 1
The issue occurred as what layout u earlier uploaded is completely different in terms of format.

I am outside, Will update u soon.
 
Each time u changing the layout & asking that same is not working!!:(
 

Attachments

  • Sarfraz Khan.xlsx
    13 KB · Views: 4
Dear Sir,
Thanks for your help and sorry for disturb you, I found the problem is that system generated report is considering the time I need to do text to column once I do text to column formula works or I have to press F2 on each column.

Please let me know if there is any solutions for this. because it will take hrs to do text to column and F2 as well.

Thanks a lot once again.
 
First, Are u able to upload the raw data.
Second, Use Paste Special...

Type 1 is any empty cell
Copy that cell
Select the all range where f2 is required
Press Ctrl+Alt+V
Click on Multiply
Press Ok

Now u have converted the range. I also did the same.
 
Back
Top