3

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

theChrisKent
  • 6,001
  • 21
  • 34
René M.
  • 31
  • 2

2 Answers2

2

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)

Christophe
  • 5,301
  • 5
  • 33
  • 60
1

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.

Eric Alexander
  • 43,293
  • 10
  • 53
  • 93