Page 3 of 3 FirstFirst 1 2 3
Results 21 to 24 of 24

Thread: Need help with total monthly hours

  1. #21
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10


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

    Quote Originally Posted by p45cal View Post
    It does not! it adds the value 12 and doesn't even look at row 12! In this context it adds 12 days (=288 hours). Barmy.
    Until you get formulae right in the cells you want to sum, you've no hope of getting the correct total hours.
    I'll look at your newly attached file later - out of time at the moment.


    I took the 12 out and if you key in 0:30 it row 12 it still subtracts from row 16 which is what it is supposed to do. I've tried every format I could and formulas. I was hoping using =NETWORKDAYS would work but to no avail. Everything is working perfectly except the highlighted cell. I have the original that I calculated manually and the total hours for the month should be 103:12:00. I'm not really worried about the seconds. Unfortunately this is something I don't think Excel can do. The second attachment I created was not a problem except having to calculate the billable times manually in rows 12 and 25.

  2. #22
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,886
    Articles
    0
    Excel Version
    365
    Enter times as follows: If it's 2:05 in the afternoon enter as 2:05 PM or 14:05.
    The attached should handle times across midnight, but check.
    Attached Files Attached Files
    Last edited by p45cal; 2021-01-15 at 11:30 PM.

  3. #23
    Seeker dcope7's Avatar
    Join Date
    Jan 2021
    Posts
    13
    Articles
    0
    Excel Version
    10
    Thank you so much. I didn't really want the 24 hour times but, I guess I don't have a choice. I really do appreciate everything you did.

  4. #24
    Acolyte Nagaraj475's Avatar
    Join Date
    Apr 2014
    Location
    India
    Posts
    29
    Articles
    0
    Excel Version
    Excel2010
    You may try. =TEXT(SUM(D16:S16),"hh:mm").

Page 3 of 3 FirstFirst 1 2 3

Posting Permissions

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