Forum Discussion
MASB70
Apr 03, 2022Copper Contributor
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 ...
- Apr 03, 2022
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.
HansVogelaar
Apr 03, 2022MVP
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.
MASB70
Apr 03, 2022Copper Contributor
Hans
Thank you so much, the formula is working. Only, cells without hours, the formula give a negative value.
Thank you so much.
Thank you so much, the formula is working. Only, cells without hours, the formula give a negative value.
Thank you so much.