Calculate time difference in seconds (using text fields)

Time fields in Castor only capture hours and minutes. If you want to capture time in the format hh:mm:ss, you need to use text fields. However, you can calculate with those as well!

To calculate the difference between two text fields where you are capturing time as hh:mm:ss, you can use the following formula