Product Tip: How to find the number of hours or days between two dates in a Kissflow form

You want to find the number of hours or days between two dates. To do so, use the following formulas:

For hours, datediff(time_started, time_finished,"HOUR")

For days, datediff(time_started, time_finished,"DAY")

 For example, let’s have two fields called time started and time finished. In order to find the hour difference between them, create a third field called time spent and enter the formula datediff(time_started, time_finished,"HOUR") and click Save.