Forum Discussion
Solved
Calculate wage by hours
Hi everyone, I need a function that calculates the wage by hours. Example Andrea worked from 19:00 - 4:00 am From 19:00 -to 1:00 the wage per hour. is 2,000 ƒrom 1:00 - 4:00 the wage per hour ...
It would be better if you provided the general rule, but with your example:
Let's say start time is in A2 and end time in B2.
=24*MOD(TIME(1,0,0)-A2,1)*2000+24*(B2-TIME(1,0,0))*2500
Format the cell with the formula as General or as Currency.
It would be better if you provided the general rule, but with your example:
Let's say start time is in A2 and end time in B2.
=24*MOD(TIME(1,0,0)-A2,1)*2000+24*(B2-TIME(1,0,0))*2500
Format the cell with the formula as General or as Currency.
Hans, thanks for your response.
I will try to be more exactly, please check the next example:
A. B. C. D
1 Name Clock In. Clock out. Wage
2. Julia. 19:00. 3:00 ?
3. Andrea. 21:00 4:00. ?
Wage hours
From 19:00 to 1:00 ¥2,000. From 1:00 to 5:00 ¥2.500
I will appreciate your help. Thank you
MASB70
I will try to be more exactly, please check the next example:
A. B. C. D
1 Name Clock In. Clock out. Wage
2. Julia. 19:00. 3:00 ?
3. Andrea. 21:00 4:00. ?
Wage hours
From 19:00 to 1:00 ¥2,000. From 1:00 to 5:00 ¥2.500
I will appreciate your help. Thank you
MASB70