Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have created a simple list where we record time spent on troubleshooting customers. But now I would like to create a simple formula for a Calculated field, but I can't get it to work.

We have two hourly rates.

  • Number of minutes times 0.75
  • Number of minutes times 0.66

What I would like is to select the applicable rate from a dropdown menu and have a calculated field that calculates the number of minutes that need to be charged according to the selected rate.

I have the following fields:

  • Minutes (total number of minutes worked)
  • Hourly Rate (Rate 0,75 or 0,66)
  • Minutes to charge (caluclated automatically)

So the formula should be for instance......:

If "Hourly Rate" is 0.75 than "Minutes" times 0.75, BUT if "Hourly Rate" is 0.66 than "Minutes" times 0.66...

I am using Sharepoint 2010

share|improve this question
add comment

2 Answers

I would agree with PirateEric that SharePoint will just do the calculation.

That said, you might want to check if the users have selected a rate first. In this case your calculated column would be:

=IF(ISBLANK([Rate Column]),0,[Rate Column]*[Minutes Column])

(output format: number)

share|improve this answer
add comment

If the users are submitting an item and the rate and minutes are fields in the form, then you'd just need to do something like =[Rate Column]*[Minutes Column].

This is a great reference on calculated columns.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.