Forum Discussion

mmilbourne's avatar
mmilbourne
Copper Contributor
Jan 17, 2023

Overtime calculations based on different rates.

Good Morning,

I need to create a spreadsheet to track hours worked and overtime, however each job worked could have a different base rate and a different time that overtime starts after. for example

Job 1: Base rate is $306 and overtime starts after 8:00

Job 2: Base rate is $406 and overtime starts after 12:18

I am looking for a way to be able to select what job it is and the sheet will be able to select the correct numbers to do the calculations.

the rate that overtime pays is the same, regardless of the time it starts (.85656 cents a min)  

 

Thank You,

Matt

excel
office 365
    • mmilbourne's avatar
      mmilbourne
      Copper Contributor
      Jan 28, 2023

      HansVogelaar 

      Thank You! that worked great, 

      I do have one other question; I have attached the sheet I am working with. 

      I need to be able to calculate the time spent in a hotel (held away) on a round trip it is the end time of the previous day and the start time of the next day.

       

      Thank You.

      Matt M.

Resources