Forum Discussion

MASB70's avatar
MASB70
Copper Contributor
Apr 03, 2022
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 ...
  • HansVogelaar's avatar
    Apr 03, 2022

    MASB70 

    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.

Resources