If you can import that data into a field of type time, you won't need any calculation. A time field will display your time in the 06:15 format, but the value in the field will be in seconds.
If you import the data into a text field, GetAsNumber ( GetAsTime ( YourTextFieldWithThisData ) )
Should also return the time in seconds, in number format.
This is what i have done i need to get the value of dur_sec to be the calculated value of min_sec witch is in the 06:06 format.
I have attached a pic of the layout.
Above solution does not work dur_sec stays empty.
Note that you an use the Upload an image controls below the Post a Answer box to upload a jpg file so that it appears in your posted message.
By selecting and right clicking, I was able, however, to view the image. I made two different suggestions and you appear to be trying to combine the two instead of trying them separatly. GetAsNumber ( GetAsTime ( ) ) was to be used if your data was of type TEXT, not of type TIME--as might happen with certain data import operations.
Using the time field min_sec, all you need use for the calcualtion field is just the name of the time field. Use:
min_sec as your calculation for the dur_sec field.
But note that because you have set up a number field with an auto-entered calculation instead of a calculation field that returns a number, making this change won't affect any existing records, the change will only occur for any new records that you create. Try using a field of type calculation instead of a field of type number of dur_sec. You can click dur_sec in the manage | database window and use the drop down to change the field from number to calculation to make this change.
Thank you so much working like a charm