# Thread: Calculating Time Sheets (Excel 2000)

1. ## Re: Calculating Time Sheets (Excel 2000)

Try the attached.

2. ## Calculating Time Sheets (Excel 2000)

If possible, could someone take a peek at the Excel Time Sheet I am trying to create for the secretarys to use in our building? I have placed 2 comments into the cells that I need help with. Basically, I am trying to add two IN's & two OUT's together, and then anything that falls over the regular 8 hour workday I want to fall into a time and a half cell to the right of it. Thanks so much for anyone who is willing to take a stab at this one for me. Means a bunch.
Thank you
I am editing this because the first problem I had, I think I have figured out...=SUM(E9-D9+G9-F9) Seems to to the trick in the worksheet I need it to, but the second for over flow over 8 hours still has me stumped...All I can think of is =IF(SUM(H9>8), but that is all i got at this moment. If its greater then 8, I want the overflow to fall into cell I9, which would be 5 in this instance...

3. ## Re: Calculating Time Sheets (Excel 2000)

Thank you so very much Legare. As always, "I salute you"...[img]/forums/images/smilies/smile.gif[/img]