Hi,

I`m trying to calculate overtime when I have more than 40 hours per week.

I have an spreadsheet where I enter the data like start time, end time and brake as result I have for example 57:00 Hours per week and need to calculate 40 hours per regular rate and the hours over 40 by 1.5.

So far tried

A1 = 57:00 - total hours

In cell B1 I`m using IF function: IF A1>40; total hours-40;else =0 this way i will get overtime hours or 0 if there is no overtime =17 in current example. Then in next cell C1 =A1-B1 = 40 from here I can multiple the overtime hours and regular hours the way I want.

The problem here is A1 has value 57:00 and I don`t know how to proper enter the if function =IF(A1>40;A1-40;0) where 40 is regular hours. A1 is 57:00 I've tried with 40 and 40:00 but can't get any result.

How to enter this 40 to be like hours?

Thanks for your time and help!