help needed making a simple payroll calculator

please forgive me if this is a bit of a noob question or if i overlooked some forum custom or rule in asking this here.

i have a payroll calculator where all the hours are summed up and shown in a cell. I'm trying to have it only show a maximum of 40 hours with any additional hours being shown in a different cell. the purpose of this being to separate regular hours from overtime hours.
I've been trying to figure this out using =SUMIF(R28:R34,">40") and have been unsuccessful

If anyone could show me how to properly do this the help would be greatly appreciated.


Screen Shot 2017-04-19 at 12.59.14 PM.png

EDIT: a bit more clarification. i want the TOTAL HOURS to cap off at 40 and i want a seperate formula to either use that sum or add up the numbers itself and show all hours logged after 40 hours

Formula:

Please Login or Register  to view this content.

Welcome to the forum.

In your 'Total Hours' cell (R35 I think?), use this:

Formula:

Please Login or Register  to view this content.

In your 'Overtime' cell (or whatever you want to call it), use this:

Formula:

Please Login or Register  to view this content.

Make sure both cells are formatted as [h]:mm or you'll never see more than 23:59.

Hope that does what you need.