Good approach to automatically calculate the total hours of intership of a student

Hi there,

I'm currently trying to implement a way to automatically calculate the total hours of an internship given the start and end date of that internship.

we also have other parameters such as:

• the days of the week that are worked (ex. monday to wednesday)
• the amount of hours worked per day

I've tried different approach such as counting the amount of mondays, tuesdays and wednesdays inside the start and end date and then multiply the amount of each by the amount of hours woked per day to get the total hours worked during that internship. Althought, I cant seem to find a way to make it work.

Given those parameters:

• start date
• end date
• days of the week that are worked
• hours worked per day

Would you be able to suggest an approach that could make it all work?

Thank you!

Let me check on your requirement and revert.

Sorry for the delay.

You may use an Input table with columns showing days of the week with start and end times.

You can use calculation on the input table to get the hours worked and then total it over the internship period to get the total hours.

Here is a useful ticket: https://www.jotform.com/answers/2890771-calculate-time-in-and-out-using-the-input-table-dropdown

Could you try that and let us know?