Hi everyone! Kindly asking for your help for formula in airtable.
I’m trying to keep track of our team’s first response time and completion time duration for our Airtable tickets but we would like to exclude the count for non-working hours, weekends and holidays; our working hours will only be from Monday to Friday, from 8:00AM to 5:00PM GMT +8.
Currently, I’ve already set it up like this:
First Response Time duration in minutes
DATETIME_DIFF({First Response Time},{Opened date & time (PHT)}, 'minutes')
and Overall completion Time duration in minutes
DATETIME_DIFF({Resolution Time},{First Response Time}, 'minutes')
This is it looks like at the moment.
Hoping for help from anyone! thank you in advance!