Time Off Hours Request Duration Formula

[John_M]

Here’s what I need, if someone would be so kind as to assist…

I have a Submitted at column which tags the date/time the record was created from a form entry.
I have a Completed column which tags the date/timestamp when the Completed box is checked, which concludes the job duration.
And I have a Duration column which has the following formula:

DATETIME_DIFF({Completed},{Submitted at},'minutes')/60

We work 7am-4pm, M-F… What I need is that duration field to exclude off hours, before 7am, and after 4pm, to get a true measure of the work hours that job took.

Any help would be greatly appreciated!