Calculate time duration for job.
I am working on solution that need to calculate time duration for jobs.
For instance: this solution for tech support company. so customers will request new service request, that has 4 service status. those are
status 01 is Not assign : this is default value, each new record will have this value when new record create. (record time stamp )
Status 02. Inicial : admin review the service ticket then admin assign this job in totech support member in this status(record time stamp )
status 03 working: tech member will review the job and he start to change to working status ,(record time stamp )
status 04 finished: when the tech member finished the job record time stamp.
result: Now i created another calculation that will do this status04 - status02. .So tech company can see how much tim they spend to fix the issue.
This company works on 5 week days 8am-5pm. saturday and sunday and public holidays does not working. so what i want to do to filter only working hours on working days.
The reset hours should not be calculated. I already created new table for public holiays and plan to linked that holiday date with service record table.
How can i acomplish this time record which only calculate working days and working hours ?
Thanks and help appricieated.