Calculate how much business time it happens between 2 dates (weeks, days, hours, minutes)

Question

Hi,

I'd like to know if you can help me with this: I'm trying to calculate how much business time it happens between 2 dates (weeks, days, hours, minutes), for example:

* Date A: 2022-08-18 10:00 AM
* Date B: 2022-08-26 02:30 PM

* BusinessDays (business days are considered to be Monday to Friday, 9am to 6pm)

I need to calculate the business time between Date A and Date B: 1w 1d 4h 30m

Thanks in advance!!

Dan Wade_zwrsyh · Answer

Honestly, I added an automation handler and call an webhook with the issue payload. My webhook endpoint calculates the hours, and updates the field. Or, returns that value back.

Nicolás Donnelly Kehoe_89lo7l · Answer

Thanks a lot Mark! I really appreciate your support!

I'll also try to apply what you have shared with me before.

Mark Segall · Answer

Unless someone beats me to it, I'll spend a little time on this later today to try and help with exact math functions.