Calculate billable hours between two dates
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. ...
Forum Discussion
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-...
https://community.quickbase.com/quickbase/topics/date-time-duration-formula-in-hours-excluding-12am-...