AnsweredAssumed Answered

Hi there total newbie need some help please

Question asked by DavidHeunis on Dec 13, 2012
Latest reply on Dec 13, 2012 by DavidHeunis

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

Outcomes