I have a field where I can enter a date that someone worked and it will be overtime. If they work on Saturday, they will get paid time + 1/2. If they work on Sunday they will get paid double their normal pay. That being said, I want to enter the date (ie: 4/15/16) and then it can determine what day of the week that is. I have that part figured out. Now when it is a Saturday, I want to multiply the number of hours worked times 1.5 or if it is a Sunday I want to multiply the number of hours worked times 2. What would my formula be?
The whole sequence would be
1) enter date (4/16/16)
2) enter number of hours
3) automatically display the day of the week (I have that part figured out)
4) calculated field (number of hours x if(day of week = Sunday, 2, 1.5) x 25)) this would be currency
I am looking to capture the dollar amount spent on overtime
Do you have an hourly rate field for the dollars?
Is it just the dollar amount for overtime or ordinary time & overtime?
You can actually use a nested iif statement instead of VBA, I just prefer VBA.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!