help needed making a simple payroll calculator

1. 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

2. Re: help needed making a simple payroll calculator

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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1