+1Please help write a formula to take estimated hours time different frequencies (daily, weekly, monthly) and calculate monthly hours.
I currently have box for estimated hours, and radio buttons for different frequencies (daily, weekly, monthly, quarterly, yearly).
Best answer by MarkShnierYou
There is more than one way to write this formula, but probably the most concise way of doing it is using the Case function. That is because we are going to repeatedly be checking the same field to see what the value is.
Case([Frequency],
"Daily", [Estimated Hours] * 20,
"Weekly", [Estimated Hours] * 4.33,
"Monthly", [Estimated Hours],
"Quarterly", [Estimated Hours] / 3
"Annually", [Estimated Hours] / 12)
+11Can you provide a sample of the expected output? So for instance is estimate hours a numeric field that users type numbers into. And let's say they put in "8", what do you want to see for daily, weekly, monthly?
+24Can you give us numerical examples for each of the daily, weekly, monthly, quarterly, yearly choices, assuming that the estimated time is 1
+1HI! Thank you for responding! Here's some examples. Please let me know if there is something else I can provide.
Need QB formula to calculate Monthly hours based on inputs.
Estimated Hours (numeric field): 5
Frequency (field uses radio button) Weekly
OR
Estimated hours: 2
Frequency radio button: Daily
THANKS
+24Not all months have the same number of days or weeks. For the purposes of this calculation, how many days are there in a month? How many weeks are there in a month.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
