Kuroshi Posted January 18, 2020 Report Share Posted January 18, 2020 I have a field that has a format of mm:ss.00. I want to have a formula that will convert this as seconds only. Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted January 18, 2020 Report Share Posted January 18, 2020 Please use the formula below: CONVERT(FLOAT,SUBSTRING([@field:timefield], 0, (Charindex(':', [@field:timefield], 0))))*60 + CONVERT(FLOAT,SUBSTRING([@field:timefield], (Charindex(':', [@field:timefield], 0)+1), 5)) For more information regarding the function reference, you may want to check out this Howto article: https://howto.caspio.com/function-reference/ Hope this helps. -Barbie Quote Link to comment Share on other sites More sharing options...
Question
Kuroshi
I have a field that has a format of mm:ss.00. I want to have a formula that will convert this as seconds only.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.