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.
Any ideas?
Anonymous shared this idea · May 24, 2019
Comments
1 comment
Hi,
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 support@trackvia.com with the details of your account as well as table/field names.
We look forward to hearing back from you.
Regards,
Cristina
Please sign in to leave a comment.