Timesheet - How to add up total regular and OT hours in seperate rows?

Hi,

I'm creating a time sheet and was wondering to do the following.

I have a column with the total hours for the day in each row.
Under these rows there is a Total Regular Hours row and a Total Overtime hours row.

What I'd like to do is have all the hours 8 or less added up in the Regular row and anything after 8 hours will be added to the overtime row.

For example if in day one I imputed 10 hours and day two I imputed 6 hours,
It would add these up like this:

Regular Hours: 14
Overtime Hours: 2

Thanks in advance.
=)

Dino

See attached:

Please comment.

Dave

Hey Dave,

Thanks a lot. I'm almost there.

I had to drag the C2 formula down the column and
that made it work for the rest of the days.

Also change the formula of D15 from =SUM(D8) to =SUM(D2:D8)

It adding the overtime hours great, I just need to get a total of regular hours now. D14 is adding all the hours including overtime.

Thanks!

Dino

Thanks for the post and the link.

Checking out everything now.

Quick question, how do you make it so there are large spaces between your letters in the posts.

When I try putting multiple spaces between letters like A B C
it always gets truncated to on space. A B C

aha good idea. Ya it sure help to explain things in that format.

Thanks again.

Dino