Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: I am excel stupid

  1. #11
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    4,077
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am excel stupid

    Remove personal info, upload the file that shows the 0:00 with my formula in place and post a link, I'll check it out.

  2. #12
    New Member
    Join Date
    Aug 2018
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am excel stupid

    EMPLOYEE TIME SHEET
    NAME: Bailey, John WEEK ENDING: 8/12/18
    JOB START END COOK #134 DUPAGE #701 LAKE #150 WILL # 176
    DATE NAME TIME TIME R OT R OT R OT R OT MILEAGE EXPENSES PARKING
    8/6/18
    8/7/18
    8/8/18 8
    8/9/18 8
    8/10/18 8
    8/11/18 0:00
    8/12/18 0:00
    TOTAL HOURS 0 0 0 0 0 0 24 0
    REGULAR HOURS 24 MILES 0 PARKING 0 SIGNATURE
    OVERTIME HOURS 0 EXPENSES 0 DATE
    =L$4-(7-ROWS(B$8:B13))

  3. #13
    New Member
    Join Date
    Aug 2018
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am excel stupid

    I don't know what is going on, i try to upload the workbook and it doesn't post. Honestly I don't know how to post a work book

  4. #14
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    4,077
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am excel stupid

    ? Just do the same as you did in Post #6 .

  5. #15
    New Member
    Join Date
    Aug 2018
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  6. #16
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    46,940
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    6 Thread(s)

    Default Re: I am excel stupid

    I don't know what is going on, i try to upload the workbook and it doesn't post. Honestly I don't know how to post a work book
    It posted just fine. You just need to read the message that it popped back to you that states that your post requires Moderator approval before you can see them on the public forums. Please be patient and wait for approval and do not attempt to post it again (I deleted your duplicate attempt).

    This is done on noob accounts to control Spam that is often posted in links and images. A few more posts, and your account will not be subject to this restrictions anymore.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  7. #17
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    4,077
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I am excel stupid

    Somehow you got B13:B14 Custom Formatted Date/Time, that's why I had suggested for you to check the formatting in my Post #9 .

    Either highlight B13:B14, right click, format cells, choose "Date", OK

    Or, select B8, drag the cell handle down (little square at lower right corner of cell) to B14.

    Either way will fix it.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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