How to calculate number of hours?

Ola.
Estou precisando fazer formulário para calcular a diferença de entre duas datas
Ja fiz varias pesquisas e não descobri.
Exemplo:

Início: 01/08/2023 08:00
Fim: 01/08/2023 09:00

Preciso calcular a quantidade horas entre as datas.

Segue print do formulário em questão

Hi Bioanalise,

Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. I am sorry you are having trouble with this. Yes, it is possible to calculate the number of hours worked per day. But, we can do this if the hours are in 24 hours format. Let me show you how:

1. First, set your time in your Date Picker element to 24Hours format.
2. Next, add a Substring Widget to extract the Hours from the Date Picker element.
3. Then, add this condition:

Here's the result:

You can also hide the Substring Widget:

If you want to clone this Demo Form for testing, you can do so. Let me show you how:

1. First, copy the URL of the form that you want to clone.
2. Then, go to My Forms and select Create Form in the upper-left corner.
3. Next, click on Import Form and select From a Web page and then paste the Form URL of the form you want to clone in the URL field.
4. Lastly, click on Create Form. That's it.

Give it a try and let us know how it goes.

Very good, I managed to complete 90%, but my result of total hours is showing a value with two decimal places. that is, instead of displaying a number with one unit, it is displaying two decimal places. What type of field did you use to fill in the total hours? Or how do I make it show me only a maximum of two decimal places?

Hi Bioanalise,

Thanks for getting back to us. For the total hours, my colleague use a short text widget and then add a conditional logic to get the total number of hours.


Here's the demo form. Feel free to clone the form to test and check the settings. Reach out again if you have any other questions.