Apr 16 2022 06:47 PM
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
From 1:00 to 4:00 the wage is 2,500
The function that I was using is: =24*MOD(TIME(1,0,0)-B1,1)*2,000+24*(C1-TIME(1,0,0))*2500
That I see using this function is when the person doesn't work passing the 12:00 am the function fails.
Do you know how to resolve this issue?
I will appreciate your help.
Thank you
A B C. D
1 Tina 22:30 4:00 12,500
2. Julia 19:00. 1:00. 12,000
3 Rob. 19:00. 23:30. ?
Apr 16 2022 07:25 PM
Before we deal with the formula, I'd want to understand the table. It seems that there's a big gap in the rate schedule: what rate applies between 4:00 and 19:00?
And why the question mark on that one row? Isn't the answer simple?
Rob. 19:00. 23:30. ?
That looks like 4.5 hours at 2,000. i.e., 9,000 Right?
Apr 16 2022 07:41 PM
Apr 17 2022 12:25 AM
Did you look at the last reply in Calculate wage by hours ?
Apr 17 2022 01:34 AM
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