in cell C705, you have this formula...
=MAX(MIN($P$704-$Q$704+O704,4),0)
effectively, what this is doing is 1st, determining the minimun between $P$704-$Q$704+O704 (holiday hours less total hours plus contract hours) and 4, and then finding the maximum between that answer and zero. not sure of your logic, so im uncertain if that is what you are intending to do?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
My excel skills may be somewhat limited, but I have managed to get the upload to split out the overtime premium payable based on 1/3, 1/2, and double time as required by the company.
The upload has been tested in sage and works perfect.
My problem now is finding a way to get excel to recognise that if someone works on saturday, then the rules change.
Unfortunatly, I can't get it to work, and maybe I need to approach the problem differently.
Any advice, better still a solution would be greatly appreciated
Sue
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
suma 
Register To Reply
Bookmarks