Photo by Markus Spiske on Unsplash

Have you ever heard a marketer complain about sales wasting their hard earned leads?

Have you ever witnessed a support department blame Friday deployments on high time to resolution numbers?

Have you ever wondered why your longer tasks’ cycle time seems to balloon?

Well wonder no more! My hunch is that all of these questions are affected by the work hours that your employees are keeping. If you’ve got this data stored in a database use this function to help you determine the difference between two timestamps in regular time and business hour time. At my day job we use Google’s BigQuery as our data warehouse. Your mileage using this function may vary depending on what database you need to adapt this for.