# Calculating Regular Hours and OT in Timesheet

1. ## Calculating Regular Hours and OT in Timesheet

SOLVED!

Hello All,

I have a pretty basic timesheet that I created and wondered if anyone out there can help solve my question.

What formula would be best for capping a cell of one employee's total hours worked at 40 and then putting the remaining balance in the cell next to it?

An example of what I want to do:

TimeSheet Capture.PNG

Thanks!

z0rd  Register To Reply

2. ## Re: Calculating Regular Hours and OT in Timesheet

assuming you have monday to sunday in rows 1 to 7

you could have REGULAR HOURS as =if(sum(a1:a7)>40,40,sum(a1:a7))

then

OVERTIME HOURS as =if(sum(a1:a7)<40,0,sum(a1:a7)-40)  Register To Reply

3. ## Re: Calculating Regular Hours and OT in Timesheet

This looks like it will do the trick. Thanks! Nathansav  Register To Reply

4. ## Re: Calculating Regular Hours and OT in Timesheet

you will need to format the total as [hh]:mm:ss also  Register To Reply

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