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

  • Profile Image
    Vincent 
    Asked on November 04, 2021 at 05:36 PM

    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!

  • Profile Image
    gerardw
    Answered on November 05, 2021 at 12:21 AM

    Let me check on your requirement and revert.

  • Profile Image
    gerardw
    Answered on November 05, 2021 at 10:24 AM

    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?