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 is 2.500

 

Is there only one function for this problem?

 

Thank you

  • 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.

8 Replies

  • 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.

    • MASB70's avatar
      MASB70
      Copper Contributor
      Hans
      Thank you so much, the formula is working. Only, cells without hours, the formula give a negative value.
      Thank you so much.
    • MASB70's avatar
      MASB70
      Copper Contributor
      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

Resources