Divide a number by duration field

Question

I have a simple formula numeric field that i want to calculate ; formula below. The days in this invoice is a formula duration, getting error "Operator cant be applied on types number duration"

[Total]/[Days in this invoice]

------------------------------
Ermias Bean
------------------------------

del · Answer

awesome, thanks, works------------------------------Ermias Bean------------------------------

markshnier__you · Answer

Try this[Total]/ToDays([Days in this invoice])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

amberpolston · Answer

Mark,What if your duration field fluctuates duration...&nbsp; Like some records are Hours but some are Days.I have a formula duration that calculates the amount of time between 2 date/time fields.&nbsp; Then I want to take that and multiply it by a currency.4 days * 1004 mins * 100------------------------------Amber Polston------------------------------

markshnier__you · Answer

If your rate is say 100 per 24 day,&nbsp; then you would convert to hours and then multiply.Like ToHours([my duration field]) * 100------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

sorry correctionToHours([my duration field]) *&nbsp; .. times whatever your Hourly rate is.or elseToDays([my duration field]) *&nbsp; .. times whatever your Daily rate is.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Divide a number by duration field

Related Content

Roundup whole number

Calculating number of days between two date fields

Add hyphens to phone number field

Duration Fields with Pipelines

Reference Numbers Displaying Instead of Names in QuickBase