Of course you can do math with times:
Add/subtract times to/from each other (result: number), and add/subtract units of seconds to/from times (result: time).
Maybe present a concrete example of what you're trying to do.
I want to run a script and do some math with the selected time value and other values that the user selects which are number values
"…do some math…" – What maths exactly? Can you elaborate please?
test 2::Tank Qty / teat 2::run time
this results .00227623
test 2::Tank Qty is a number format which is 295
test 2::run time is a time value which is 36:00
295/36 should equal 8.19444
Keep in mind that time functions in FileMaker work with seconds. E.g.:
Time ( 1; 59; 0 ) + 60
Edit: sorry, I had this open in a browser tab and our replies crossed.
sorry its type that I meant to say instead of format
Multiply your result x 3600 -- the number of seconds in an hour.
Thanks works great