dkey Posted August 17, 2017 Posted August 17, 2017 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 Posted August 17, 2017 Posted August 17, 2017 (edited) 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, 2017 by comment 1
dkey Posted August 17, 2017 Author Posted August 17, 2017 (edited) Thank you very much it works perfectly Edited August 17, 2017 by dkey
Recommended Posts
This topic is 2920 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now