need help with counting cells for time sheet

[watmie]

Please help new to this making time sheet for 12 hr shift
I have figured out how to count total hours but would like to count Stright time and over time

M14 T12 W12 T12 F0 S0 S12= 62 total hours
M-T need to count each cell from 0 to 12 to total 40 and stop= 40 stright time
then count cell M-T number greater than 12 and F-S to its total= 16 overtime

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[watmie]

I hope this helps is how to post attachments

[watmie]

This is our timesheet 12 hours a day 2 week pay period no lunch we enter hours worked Monday - Sunday and it totals the hours.
Then at end of the week we have to enter ST stright time and OT overtime hours for everyone I was hoping that this could be done
by excel so no mistakes would be made and with 60 employees it takes a while to do this manually.

[HansDouwe]

Please try in K5: =MIN(40,SUM(C5:F5)) and copy down
Please try in L5: =SUM(C5:I5)-K5 and copy down

[hsotnas.tnawas]

Hi Watmie,

Please find the solution

Regards,
Santosh

[watmie]

very close to working when input 14 hours in cell it will not count the 2 hours as overtime until 40 is meet
I don't know if this is even possible to do any monday - thursday over 12 is counted overtime
and added to friday - sunday overtime.

still working on it thanks
leaving to work in the field wont be back for few hours thanks again

[HansDouwe]

I don't know if this is even possible to do any monday - thursday over 12 is counted overtime

Yes that is possible, but in your sample sheet no expected results are filled in for these cases.

Please try in V5 and copy down

Please Login or Register  to view this content.

[watmie]

I would never have figured that out I thank you all so much my pay sheet just got
100 percent easier

[HansDouwe]

You are welcome. Glad to have helped.

Please considder adding reputation to any helpers you think they deserve.
In that case please click * Add Reputation left below their answers.

[HansDouwe]

Thanks for the rep .