I need help creating a survey to keep track of overtime hours for my job

User Support Form Building
, , , ,
1

Hello, good afternoon everyone, Iā€™m new here :smiley:
I need help creating a survey to keep track of overtime hours for my job.
The form itself is already created, but I need to know how to make it calculate overtime hours when selecting the entry and exit times.
For your consideration:

  • Monday to Thursday: After 6:30 PM is considered overtime.
  • Friday: After 2:00 PM is considered overtime.
  • Saturday and Sunday: After 8:00 AM is considered overtime.
2

Welcome to the community, @maxiromero! You should be able to do it as outlined in the image shared below:

In the survey tab of your XLSForm:

image
image1410Ɨ270 11.1 KB

In the choices tab of your XLSForm:

image
image261Ɨ232 3.83 KB

Data entry screen as seen in Enketo: for Monday

image
image573Ɨ702 15.1 KB

Data entry screen as seen in Enketo: for Tuesday

image
image571Ɨ702 15.3 KB

Data entry screen as seen in Enketo: for Wednesday

image
image573Ɨ702 15.3 KB

Data entry screen as seen in Enketo: for Thursday

image
image575Ɨ701 15.7 KB

Data entry screen as seen in Enketo: for Friday

image
image572Ɨ701 15.3 KB

Data entry screen as seen in Enketo: for Saturday

image
image573Ɨ701 15.6 KB

Data entry screen as seen in Enketo: for Sunday

image
image573Ɨ700 15.4 KB

Reference XLSForm:

Overtime Calculation.xls (39 KB)

1 Like
3

Good morning,
Honestly, your response was very helpful!
Thank you so much!
I just have one more question. In the survey, when selecting Saturday or Sunday, the time starts counting from 8:15 AM, which causes me some confusion.
Is there any way to fix this?
Thank you in advance for your help!

4

@maxiromero, you can also manually enter the minutes when entering time. That should solve your issue.