### Title

Hi there total newbie need some help please

### Post

Hi all

Need some help calculating a field of the following data.

I get a csv file with the duration of a call in the following format ---> 06:15

The above data field reflects time of the call meaning 06=min 15=seconds

I need to get converted into a new field but need to calculate the total in seconds

so the math is (06*60) + (15) = 375 seconds, how do i create a calculation in filemaker to automate the conversion

Can not figure out how to get around the** :**

Any help welcome.

Thanks

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.