Gross Payroll with overtime issue

[mpt13]

Hello everybody,

I am trying to calculate gross payroll, where the total hours for the week are in one cell and I need total gross payroll to be in the other without adding any more columns. Thank you
Example:

Payroll.JPG

[modytrane]

formula in C7, copied across and down.

[modytrane]

I figured over 40 hrs as overtime and overtime ay as 1.5 X reg pay.

Adjust factor of 1.5 in the formula to actual factor.

[mpt13]

Thanks so much. Works perfectly ) Have a great day

[Logit]

.
I've been following this thread with interest.

Two questions :

When the employees work more or less than 40 hours in a week, their time is listed as a whole number and a decimal. What does the decimal represent and how are
you converting the decimal portion to minutes ?

There are a number of totals shown below that do not match my calculator. I multiplied the the hours worked by the employee's hourly rate. ????

[mpt13]

Good question I am doing this as exerciser not actual payroll but good catch ) I have IN and OUT clocking and use OUT-IN*24 but I guess my formula there is wrong

[modytrane]

Can you attach a sample file? The answer to your question depends on how the cells are formatted.

[mpt13]

Yes, please see attached file. I clean it up a little. The bottom is the average clocks in and out + total of the week and the pay with your formula.

Attachment 619559

[Logit]

.
To post an attachment, you will need to use the GO ADVANCED button lower right corner of the REPLY TO THREAD. Then select MANAGE ATTACHMENTS in the next window.

The link you provided doesn't work.