I am beginner to MS Excel but i try to correct this file Formulas. I have an attendance sheet for our Company Employees.
This attendance sheet shows the salary of the month from the total basic salary / hour and overtime / hour of each
employee.
I found a problem in this sheet. When i reduced overtime charges in the last of this sheet so the Total Salary of the month
was not changing. I couldn't found any mistake in formulas.
please help me in this matter !!!!
Last edited by it_electronics2000; 06-02-2014 at 08:34 AM.
Do you have the count function on manual?
I belive it is: formula => count formula => automatic
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
can't understand count formula
Last edited by it_electronics2000; 06-02-2014 at 08:38 AM.
Bump no response
"Bump no response"
Re: Overtime per hour wage Counting Formula is not working in this Sheet
According to this sheet we got daily timings of an each employee in Column E "Working Hours".
In "Column E" each cell showing total Hours of working of each employee means the Regular
Working Hours and Overtime. Regular Job time is 8 Hours which was already supplied in G52 Cell
and regular 8 hours should be charged according Basic Hourly Rate "C54 Cell". After 8 Hours time
should be charged by Overtime Hourly Rate "C55 Cell".
The problem is existing in Column F "Daily Wages". In this column each cell should be calculating
Column E Cells timings according to Basic Hourly Rate (C54) and Overtime Hourly Rate (C55).
If any worker working till 8 hours or less than 8 hours so in Column F Cells Formula should be multiply with
Basic Hourly rate (C54) and if the worker worked more than 8 hours so Column F Cells Formula should be
multiply by Overtime Hourly Rate (C55) but when you check the Column F "Wages Cells" by manually
calculator so you found that all working hours was multiplied by Basic Hourly Rate either Overtime Hourly
rate when the time was exceeded more than 8 hours.
Please help regarding this matter i can't found that mistake how can i resolve it
Hi,
It's somewhat difficult to understand what you're asking, or at least difficult for me.
If you manually add the results you expect to see in column F in say spare column J, and add specific notes which explain the calculation then we might stand a chance of assisting further.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Dear Richard
Thanks for your kind reply attached please find the Excel Sheet as you need.
Hi,
Maybe
Formula:
Please Login or Register to view this content.
Not maybe boss confirmed !!!! YOU ARE GENIUS !!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks