Results 1 to 3 of 3
  1. #1
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Time Sheets (Excel 2000)

    Try the attached.
    Attached Files Attached Files
    Legare Coleman

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Nannette M. Padgett
    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...
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Time Sheets (Excel 2000)

    Thank you so very much Legare. As always, "I salute you"...[img]/forums/images/smilies/smile.gif[/img]
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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