Results 1 to 46 of 46

Subtracting hours in a work schedule

Threaded View

  1. #35
    Registered User
    Join Date
    08-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2002
    Posts
    25

    Re: Subtracting hours in a work schedule

    I have been working on my worksheet to no avail. But, I will keep trying to find my answers, trying different approaches.
    I have now run into another problem with my schedule:
    In row 4 all of my times are adding up correctly (except I would like to subtract 30 minutes for lunch times daily).
    However, as you can see, in row 8, if an employee works different hours, as in row 8 column G with 2:15-9:15 it does not compute correctly. Even my formula for for 9G is not totally correctly.
    I am hoping for some help.
    I have changed the title a few times, hoping that it meets this forums guidelines. If I am not meeting the guidelines please let me know.
    Thank you for any help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Bookmarks

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