• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

What Am I Doing Wrong with this Formula?


New Member
Here's what I need - I15 x 0.0885 up to 40 hours only and converted to 2 decimal points so I have =MIN(I15*0.0885, 40*0.0885)*24 but currently in I15 I have 40:30:00 and it's calculating that 30 minutes but I only want it calculated to 40 hours.

Help please!