Calculate Phone costs nightmare

[dkey]

I have 2 time fields defining the time for the beginning and the end of a call  which I trigger at the beginning and end of the call:

the result is another time field.

Another numeric field gives me the actual cost per minutes in Euros as 4,7

However I don't know how to calculate the decimals in the cost field as FMP time function only gives hours, minutes and seconds.

If I have a resulting call time as 00:06:14 and the cost is 4,7 cents per minute what is the appropriate formula to get the actual cost for the call?

 

Thanks a lot

[comment]

  On 8/17/2017 at 4:32 PM, dkey said:

what is the appropriate formula to get the actual cost for the call?

Expand  

In calculations, time fields are evaluated as seconds, so try =

CallTime * CostPerMinute / 60

 

If the cost is given in cents rather than Euros, then of course divide by 6000 instead of 60 to get the price in Euros.

 

 

Edited August 17, 2017 by comment

[dkey]

Thank you very much it works perfectly

Edited August 17, 2017 by dkey