Financial Calculations based on time
Hi, I am fairly new to FileMaker 10. I am having an issue with a calculation involving time and the cost per amount of time. I am looking for help in finding a formula that will allow a field called "Total Cost" to get the total time (in increments of 15 min.) and then add the $ amount based on the total time ( i.e., if the total time is 15 min. then the cost would be $10.00, if the total time is 30 min. then the cost would amount to $20.00). I have been beating my head on my desk for awhile about this one, so, any input would be most appreciated. Thanks, James.