Forum Discussion
Function that calculates salaries depending on the IN and OUT time
Hi everyone, I am looking for a dynamic formula that can calculate work schedules. Depending on the schedules, the wage value changes. Example Criteria From 19:00 to 1:00 am, the wage is 2,000 Fr...
Mathetes,
Thank you for your interesting in my problem.
The schedule is at nighttime.
Then the rate is from 19:00 to 1:00 the wage is 2,000 per hour
From 1:00 until 4:00 in the morning the wage is 2,500 per hour
In the case of my example Rob, yes the wage will be 9,000, however the formula that I'm using now has problems when the worked time doesn't pass 24:00
I hope this explanation can help you.
Thank you
Thank you for your interesting in my problem.
The schedule is at nighttime.
Then the rate is from 19:00 to 1:00 the wage is 2,000 per hour
From 1:00 until 4:00 in the morning the wage is 2,500 per hour
In the case of my example Rob, yes the wage will be 9,000, however the formula that I'm using now has problems when the worked time doesn't pass 24:00
I hope this explanation can help you.
Thank you
Did you look at the last reply in Calculate wage by hours ?
Hans
Sorry I did not find your reply until right now.
I will try the formula updated when I get home in few minutes.
Just say thank you for your time and your help
MAS