Discussions

Expand all | Collapse all

Calculate billable hours between two dates

  • 1.  Calculate billable hours between two dates

    Posted 10-26-2018 19:50
    I am needing to Calculate the billable hours between 2 dates, excluding weekends. 


    For example,   10/1  8am    to  10/2  8 am should be just 8 hours. but clearly 24 actual hours.
                            10/1  8am    to  10/2  5pm should be 16 hours, not 33 or whatever.

    I have tried every way I can think of to solve this but I cant figure out a good method. Please help. Thanks


  • 2.  RE: Calculate billable hours between two dates

    Posted 10-26-2018 19:55
    Check out the link about for my first answer as it excluded weekend.  Yes, that is not an easy formula !!  Try adjusting that formula to enter your own Hours of business.


    https://community.quickbase.com/quickbase/topics/date-time-duration-formula-in-hours-excluding-12am-...






  • 3.  RE: Calculate billable hours between two dates

    Posted 10-26-2018 20:11
    You sir, are a life saver. What a formula! Thank you!