-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
semi-monthly
-
W
Semi-monthly Pay Date with Different Pay Period
Payroll for my company is semi-monthly. The workdays 8th - 23rd are paid on the following 1st. The workdays 24th - 7th are paid on the following 15th. How do I use =today() to determine its corresponding payroll date? I've created the following that appears to work. Is there anything simpler or...- wasatchgirl
- Thread
- date paid pay semi-monthly workdays
- Replies: 2
- Forum: Excel Questions
-
J
Do math on hours in one column dependent upon dates in another column
Hello, I'm currently working on a pay calculating worksheet for my wife's new job that pays semi monthly. The 1st thru the 15th is paid on the 25th and the 16th thru the 30th/31st is paid on the 10th of the following month. Of course overtime (OT) is paid on everything over 40 hours per week...- JBC
- Thread
- hours overtime pay semi-monthly
- Replies: 6
- Forum: Excel Questions
-
T
Semi-monthly Timesheet with OT calculating based on daily and weekly limits
I have created a timesheet that shows overtime options. I will try to make a copy (can we upload a copy of our file?) I have created checkbox for daily and weekly overtime options. If Daily (True), OT is calculated over 12 hours, if Weekly (True, OT is also calculated over 48 hours per week)...- trs43
- Thread
- daily calculation overtime hours semi-monthly time sheet weekly calculation
- Replies: 0
- Forum: Excel Questions
