Time Calculation and Conversion - Page 2
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Time Calculation and Conversion

  1. #11
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Nope I didn't get that formula to work either. Are you using 12 hour time format or 24 when you did this formual?? Maybe that's why it's not working for me.

    Thanks so far for everyone's responses!

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 16:32, griggsbgsu wrote:
    Nope I didn't get that formula to work either. Are you using 12 hour time format or 24 when you did this formual?? Maybe that's why it's not working for me.

    Thanks so far for everyone's responses!
    Formatting doesn't matter. All time values are stored as fractions of a day regardless of format.

  3. #13
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah! It worked! But there is still the little green triangle in the corner because it says the formula is inconsistent. Know how I get rid of that?

  4. #14
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I got rid of it, you just ignore the error, easy enough! Thanks so much for the help! And I got answers so fast! You guys rock! I'll be back if I need help again. Thank you!

  5. #15
    New Member
    Join Date
    Dec 2005
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Subtracting minutes in hh:mm format, and set hours

    I see how this works, and it's great, but now I have two additional problems. I want to subtract a lunch time (not always an hour) and calculate overtime. I want to be able to put my lunch in the hh:mm format - 0:45 for 45 minutes, which I think I've figured out (see below). I also want to calculate overtime by subtracting a blank 8 hours from my total hours cell. How could I accomplish this?

    I have all cells in the hh:mm format

    I have a1=time in
    b1=lunch length
    c1=time out
    d1=total hours [ =SUM((C1-A1)-(B1)) ]
    e1=overtime

  6. #16
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Welcome to MrExcel.
    Put this in E1
    =MAX(D1-8,0)

    FYI, in future you should post a question in a new topic and reference this topic in your question.

    Best regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  7. #17
    New Member
    Join Date
    Apr 2003
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a question along the same line. If it is ok to post here, I will. If I need to start a new thread then let me know

  8. #18
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    The best is to post a new thread and reference this thread in it.

    Best regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

User Tag List

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
  •  

 

 
DMCA.com