### Title

Financial Calculations based on time

### Post

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.

If Total Time is a a time field or returns total time in seconds:

Floor ( TotalTIme * Rate / 900 )

will compute the total cost, discarding any fractional amount less than a 15 minute interval.