Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

How do I calculate cost per development hour from an average?

I want to automate the process of calculating the cost of development, based on an entry field (development hours) - so when a developer enters their project hours, it automatically calculates the cos...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
OK, so if this is a duration field type for 

[Total Design Hours] 

Then you will need to convert that to be a numeric field type before multiplying

ToHours([Total Design Hours]) * 65

That is because when you have a duration field, even though it happens to be named "hours", it is a a duration which could also be expressed in seconds, minutes, hours, days, weeks ... so you need to get it converted ot the number of hours if you are going to multiply by an hourly rate.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    Apologies for the late follow-up - travel/schedules bogged me down for a bit. So here's what I wound up with:

    If([Designer]= "Name",
    [Hours Worked] * 40.9,

    I adjust the hours-worked formula based on cost relative to designer.  Where I was getting hung up is the closing parenthesis (I needed 14 and only had 1) - once I figured that out, the formula worked.  So now, when I select a designer from my pull-down, it automatically calculates based on the hours worked and auto-populates the Cost field.