Count working hours
I need to count working hours in the range defined by "Start" and "End" fields. Both fields are Date and Time format. The working day lasts from 7 AM till 3:30 PM. I need to count time only from this range. Overtime and weekends should not be included. I can start and end work any day at any time.
weekdays() function counts only days, datedif() function includes all 24 hours and weekends.
Thank you for reaching out! You are correct, there is no one function that would take care of the scenario you are describing. TrackVia has a lot of room for customization, therefore, depending on the way your application is set up, you could use a combination of functions to get the desired result. If you would like for us to assist further, please send us an email to firstname.lastname@example.org with the details of your account as well as table/field names.
We look forward to hearing back from you.