Results 1 to 4 of 4

Thread: Subtracting Time as per sample

  1. #1

    Subtracting Time as per sample



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please view the attachment and reply to sender. somewhat time sensitive, Thank you Jim
    Attached Files Attached Files

  2. #2
    Acolyte Jean Paul's Avatar
    Join Date
    May 2015
    Posts
    22
    Articles
    0
    Excel Version
    2013
    i hoop that this the formula is ,you looking for
    Attached Files Attached Files

  3. #3
    Quote Originally Posted by Jean Paul View Post
    i hoop that this the formula is ,you looking for

    Jean,

    We are quite close, you may have missed my comments under the original spreadsheet. I need to discount the lunch and break times between 10:00 thru 10:15 AM, 12:00 thru 12:30 PM, and 2:00 thru 2:15 therefore the answers should be as follows

    H4=3:45
    H5=1:15
    H6= :30
    H7=1:15
    H8=:10
    H9=1:18
    H10=1:02

    Thank you for your time and effort.

    Jim

  4. #4
    Acolyte Jean Paul's Avatar
    Join Date
    May 2015
    Posts
    22
    Articles
    0
    Excel Version
    2013
    with yours breaks
    Attached Files Attached Files

Posting Permissions

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