Hours Worked on Project but only Work Hours

Hi Airtable Community,

Could someone please help me out, I have two columns, one that is Start time and one is Stop Time, they both have dates and times. I use a formula to get me the total hours between the dates and times. The only issue is, some projects that have start end time of 1/12/2020 10:10 till 2/12/2020 15:30 will give me total hours but I only need it to calculate during working hours which is 7 Hours and not give me a total of hours which include when the employee is not working. Is there any formula that can take in account to only calculate total hours during work hours?

I am using this formula for total hours between the two dates.

IF({Stop Time},DATETIME_DIFF({Stop Time},{Start Time},"")/3600)

Date and Time

Thank you all for any help that can be provided.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.