Calculate billable hours between two dates

  • 39
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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
Photo of David Brogdon

David Brogdon

  • 582 Points 500 badge 2x thumb

Posted 2 months ago

  • 39
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
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-...




Photo of David Brogdon

David Brogdon

  • 582 Points 500 badge 2x thumb
You sir, are a life saver. What a formula! Thank you!