Hi there total newbie need some help please
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.