-
Mustapha_cmsAsked on July 19, 2021 at 5:06 AM
hi there,
i having a problem with calculation between two date
my problem with these date.
Date Start : 11/07/2021 at 1130hrs
Date End : 16/7/2021 at 00:18hrs
in jotform calculation the result is 4 days, 13 hours and 48 minutes
But the actual result must be 4 days, 12hours and 48 minutes
Please advise how to get the correct answer.. thanks
-
Basil JotForm SupportReplied on July 19, 2021 at 8:08 AM
Hi,
I have checked your form and you are using 0 decimal places for one field which rounds it, the hour's field value is being rounded to 13 hours.
You should use the floor function in the field instead to prevent rounding.
Please let us know if you require any further assistance.
-
Mustapha_cmsReplied on July 20, 2021 at 11:39 PM
hi,
Thank you for your advise. finally get correct result.
-
Mustapha_cmsReplied on July 20, 2021 at 11:41 PM
-
Jovanne JotForm SupportReplied on July 21, 2021 at 7:23 AM
Hi,
We will be responding to your other question on this separate thread https://www.jotform.com/answers/3233739 shortly.
Thank you!