Writing a query which standardize the days

First, a problem, how many days is a month, could be 28, 29, 30, or 31 depending which month and if it is a leap year. For this example I will assume one month is 30.436875 days.

Start by using "Enter Data" to create a mapping table of unit to number of days

Then:

1. Split your table with OperationDuration by space (first time only)

2. Split the first column by '-' (only once)

3. Change the two column types to number

4. Select the first two columns and under "Add Column" choose the Stastics button and choose Average

5. Do a merage on the table you entered and your source table using the right split column (from step1) and the first column of the table you enterd in. Use a fuzzy join.

6. Expand the merged column choosing the second column

7. Select the expanded column and the Average column and under "Add Column" choose multiply.

8. Remove all other columns. Any nulls in this column will be the result of an error.