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

12 minutes ago, dkey said:

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

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, 20178 yr by comment

Thank you very much it works perfectly

Edited August 17, 20178 yr by dkey