How do I...?

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.
Any ideas?

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Cristina commented  ·   ·  Flag as inappropriate

    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

Feedback and Knowledge Base