Hours, minutes, seconds

Hello @zsoot

You should use the TIMETODECIMAL and DECIMALTOTIME operations. You should transform both values to seconds, calculate the difference, and then transform the result to time format again:

DECIMALTOTIME(ABS(TIMETODECIMAL("00:01:25","h:i:s","s") - TIMETODECIMAL("00:01:30","h:i:s","s")), "s", "h:i:s")

Best regards.

Thanks for your reply. But i want the user to be able to enter the time in that format:
hh:mm:ss. It is possible? This would be a starting time of a video or mp3.

Hello @zsoot

Yes, of course. In fact, if you check my previous entry the values were entered in the time format hh:ii:ss (i is used for minutes because the m represents months).

Best regards.

Thanks again! Sorry, I see. One last question: where do I add this custom opration you mentioned above?

Hello @zsoot

The equations are entered through the “Set Operation” attribute in the settings of the calculated fields.

Best regards.

Sorry but I can’t change the entering Date Time format to hh:ii:ss. How/where can I do that?

Hello @zsoot

Please, send me the link to the page with the form and the equation you’re using.

Best regards.

Now I’m using fieldnam3-fieldname2 equation.

https://film.budasidehovawart.hu/hogyan-rendelhetek/

Hello @zsoot

Please, I need to check your form in action to verify the fields’ values. Could you indicate the link to the form’s page, please?

Best regards.

Hello @zsoot

Please, indicate the URL as part of a text, without https://...

I need to check the fields fieldname2 and fieldname3 to identify the errors in your equation.

Best regards.