Nov 29, 2023 06:35 AM
Hi
I have a field called {Total Duration} where the user enters the length of a video in h:mm:ss format. This formula is going to be used to calculate the costs of video editing. We charge in 30 seconds units. 1-30 seconds is charged as one unit, but 31-60 is charged as two units.
I have been using the following when {Total Duration} was set as a simple number field
Nov 29, 2023 09:58 AM
I was unable to reproduce the issue. Your formula worked fine for me.
This is unusual. Does this happen consistently if you type 31 seconds in multiple rows? Does the issue happen when you type one second? Can you share a screenshot? It might be a floating point issue, but that seems unlikely.
Nov 29, 2023 10:23 AM
How strange! I've just deleted the column, then set it up again and now its working...
Sorry for wasting your time and thank you for the help!